Use system table
all_tables.
select owner, table_name, tablespace_name, pct_free, num_rows,
blocks, avg_row_len
from sys.all_tables
where
lower( owner ) = 'tiskman' and
lower( table_name ) like 'uz_%';
Output:
OWNER TABLE_NAME TABLESPACE_NAME PCT_FREE NUM_ROWS BLOCKS AVG_ROW_LEN
----------- ---------------- ----------------- -------- --------- --------- -----------
TISKMAN UZ_TRANS_P1506 USERS 10 20314 610 188
TISKMAN UZ_STATE_S1510 USERS 10 95 5 111
TISKMAN UZ_TRANS_S1510 USERS 10 1611 54 191
...
No comments:
Post a Comment