oracle找不到 dba_tables,Oracle 数据字典表之:DBA_TABLES

//数据字典表 DBA_TABLES 与 ALL_TABLES 字段结构相同,

//其创建语句如下(以下脚本来自Oracle10g 10.2.0.3)：

CREATE OR REPLACE FORCE VIEW SYS.dba_tables (owner,

table_name,

tablespace_name,

cluster_name,

iot_name,

status,

pct_free,

pct_used,

ini_trans,

max_trans,

initial_extent,

next_extent,

min_extents,

max_extents,

pct_increase,

FREELISTS,

freelist_groups,

LOGGING,

backed_up,

num_rows,

blocks,

empty_blocks,

avg_space,

chain_cnt,

avg_row_len,

avg_space_freelist_blocks,

num_freelist_blocks,

DEGREE,

INSTANCES,

CACHE,

table_lock,

sample_size,

last_analyzed,

partitioned,

iot_type,

TEMPORARY,

secondary,

NESTED,

BUFFER_POOL,

row_movement,

global_stats,

user_stats,

DURATION,

skip_corrupt,

MONITORING,

cluster_owner,

dependencies,

compression,

dropped

)

AS

SELECT u.NAME, o.NAME,

DECODE (BITAND (t.property, 2151678048), 0, ts.NAME, NULL