テーブル情報

テーブル名取得

# 
set lines 200;
col TABLE_NAME      format a25;
col TABLESPACE_NAME format a15;
col INITIAL_EXTENT  format 99999999999999;
col NEXT_EXTENT     format 99999999999999;
col MIN_EXTENTS     format 9999999999;
col MAX_EXTENTS     format 9999999999;
select TABLE_NAME
     , TABLESPACE_NAME
     , INITIAL_EXTENT
     , NEXT_EXTENT
     , MIN_EXTENTS
     , MAX_EXTENTS
  from user_tables
 order by TABLE_NAME, TABLESPACE_NAME;


# sys権限

select OBJECT_NAME, LAST_DDL_TIME, TIMESTAMP from dba_objects where owner='XXXX' and OBJECT_TYPE = 'TABLE'

TABLE_NAME                TABLESPACE_NAME  INITIAL_EXTENT     NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
------------------------- --------------- --------------- --------------- ----------- -----------
TABLE_PRIVILEGE_MAP       SYSTEM                    65536                           1  2147483645
TABPART$                  SYSTEM                    65536                           1  2147483645
TABSUBPART$               SYSTEM                    65536                           1  2147483645
TRANSFORMATIONS$          SYSTEM                    65536                           1  2147483645



テーブル情報（項目：列）

# SYS権限

set lines 200;
col owner for a10
col table_name for a20
col column_name for a30

select owner,table_name,column_name from dba_tab_columns order by owner,table_name,column_id;



# ユーザ権限

set lines 200;
col table_name for a20
col column_name for a30
col data_type for a10
col data_length for 999999

select table_name,column_name, data_type, data_length from user_tab_columns order by table_name,column_id;


TABLE_NAME           COLUMN_NAME                    DATA_TYPE  DATA_LENGTH
-------------------- ------------------------------ ---------- -----------
DBA_IND_PARTITIONS   TABLESPACE_NAME                VARCHAR2            30
DBA_IND_PARTITIONS   PCT_FREE                       NUMBER              22
DBA_IND_PARTITIONS   INI_TRANS                      NUMBER              22