Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

USER_TABLES view select problem

627040Mar 18 2008 — edited Mar 18 2008
i 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>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2008
Added on Mar 18 2008
8 comments
436 views