Thursday, January 18, 2018

ORACLE - How get info about user`s tables

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