Error when trying to extract Oracle DDL
When I am trying to extract the DDL of a schema named ORG_OWNER the resulting DDL.sql script has these following errors
ORA-31603: object "SEQ_BUILDINGS" of type SEQUENCE not found in schema "ORG_OWNER"
ORA-06512: at "SYS.DBMS_METADATA", line 6478
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6465
ORA-06512: at "SYS.DBMS_METADATA", line 9202
ORA-06512: at line 1
The user that is running the edb_ddl_extractor script is has SELECT ANY DICTIONARY privilages.
What is causing this issue?
Accepted Solutions (1)
Accepted Solutions (1)
- Report Inappropriate Content
Solution
Hi Francis,
You can try giving ‘SELECT_CATALOG_ROLE’ to oracle user which is executing edb_ddl_extractor.sql file. This should resolve the problem.
The mentioned error comes when oracle user does not have privileges to extract metadata of object.
Let us know if this works for you.
Comments (0)
Comments (0)