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!

SELECT user_tables does not show all tables

242480Feb 8 2012 — edited Feb 8 2012

Hello,

I'm just installed Oracle 11g with the test data and a SQL workbench shows for example the Schema SCOTT with table BONUS. I logged on as user SYSTEM and expected that the SQL statement

select table_name, tablespace_name, num_rows from user_tables;

also shows the tables of schema SCOTT, but it does not :-(. I allready tried soms STAT commands like
exec DBMS_STATS.GATHER_SCHEMA_STATS('SCOTT');
exec dbms_stats.gather_table_stats ('SCOTT', 'BONUS');
but this did not help.

What is missing to show my SCOTT-Tables?

Regards, Rainer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2012

Added on Feb 8 2012

3 comments

12,445 views