Skip to Main Content
Forums

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!

Error: ORA-31603: object "TABLE_1" of type TABLE not found in schema "SCHEM

orabitsNov 21 2008 — edited Nov 21 2008
I am getting this issue, while executing the below statement in PL/SQL block from another schema (schema_2),

Statement: select dbms_metadata.get_ddl('TABLE','TABLE_1','SCHEMA_1') from dual;

ERROR: ORA-31603: object "TABLE_1" of type TABLE not found in schema "SCHEMA_1".

and it is working fine, if the sql statement run in SQL*Plus from another schema (schema_2).

Is there any special grants needs to be granted from schema_2 to schema_1 ?.

Please help...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2008
Added on Nov 21 2008
1 comment
1,576 views