oracle10g - Finding tablespace size on oracle without dba_* metatables -
i need find current tablespace size db in oracle 10g. looking around, i've found many scripts determine size using tables dba_extents, database i'm using has none of these dba_* tables.
(i'm using proxy finding table size, complicated because of table size in blobs.)
the dba_*
views part of "static data dictionary views" there 3 versions of every view, dba_
shows everything, all_
shows have access to, , user_
show own, , not have owner
column.
for example dba_tables
has tables, all_tables
table can select from, , user_tables
tables own.
the views documented in "static data dictionary views". resource if need translate dba_
all_
or user_
.
unfortunately _extents
comes in dba , user version. if want information on objects can access not own, need ask resident dba help.
Comments
Post a Comment