USER_TABLES view select problem
627040Mar 18 2008 — edited Mar 18 2008i have created a new user and created a test table using USERS tablespace with unlimited quota, ive dont grant select on user_tables to username;
i have created test table and selecting * from user_tables shows the table but selecting where returns no rows???
can anyone see a problem here?
SQL> SELECT TABLE_NAME,
2 NUM_ROWS,
3 BLOCKS ,
4 EMPTY_BLOCKS,
5 AVG_SPACE ,
6 CHAIN_CNT ,
7 AVG_ROW_LEN
8 FROM user_tables
9 WHERE table_name = 'test';
no rows selected
SQL> SELECT TABLE_NAME,
2 NUM_ROWS,
3 BLOCKS ,
4 EMPTY_BLOCKS,
5 AVG_SPACE ,
6 CHAIN_CNT ,
7 AVG_ROW_LEN
8 FROM user_tables;
TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE
------------------------------ ---------- ---------- ------------ ----------
CHAIN_CNT AVG_ROW_LEN
---------- -----------
TEST
SQL>