Skip to Main Content
Forums

SQL Developer

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!

2EA - ORA-31603: object "TABLE_NAME" of type TABLE not found in schema "NOT

736899Nov 24 2009 — edited Nov 25 2009
I get the following error when i try to view objects SQL definition by select on the table then the SQL table when I am not the owner...
ORA-31603: object "TABLE_NAME" of type TABLE not found in schema "NOT_MY_SCHEMA"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2805
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1

I am about to see columns, data, contraints, etc...for the same table, but not the table definition. Note we are on 10gR2 (10.2.0.2.0) RAC configuration.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2009
Added on Nov 24 2009
#sql-developer
1 comment
1,055 views