Error when trying to extract Oracle DDL

[Francis]

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?

[chaitalirs · Accepted 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.