cancel
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)

chaitalirs
EDB Team Member
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.

Answers (0)

Ask a Question