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

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks