Showing results for 
Search instead for 
Did you mean: 

Error when trying to extract Oracle DDL

Accepted Solution

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)

EDB Team Member

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.

Answers (0)

Ask a Question
Top Kudoed Posts