DBMS_METADATA.GET_DDL as SYS get ORA-31603
Hi!
Im trying to extract the ddl for a table (belonging to user1):
select DBMS_METADATA.GET_DDL('TABLE','his_table','user1') from DUAL;
But I get: ORA-31603: object "his_table" of type TABLE is missing in schema "user1"
How do I fix this?
Regards
U
Im trying to extract the ddl for a table (belonging to user1):
select DBMS_METADATA.GET_DDL('TABLE','his_table','user1') from DUAL;
But I get: ORA-31603: object "his_table" of type TABLE is missing in schema "user1"
How do I fix this?
Regards
U
0