Empty USER_TABLES
702520May 20 2009 — edited May 20 2009Hi,
Trying to select blocks, num_rows, avg_row_len from user_tables but the result return is empty.
I need those data to find the table size. Using oracle 10g XE
SQL> set echo on
SQL> set linesize 100
SQL> SELECT table_name, blocks, num_rows, avg_row_len FROM user_tables;
TABLE_NAME BLOCKS NUM_ROWS AVG_ROW_LEN
------------------------------ ---------- ---------- -----------
DOCTOR
HOSPITAL
PATIENT
TREATMENT
PRESCRIPTION
WARD
6 rows selected.
Thanks =)
Edited by: user11184507 on 20-May-2009 05:01