Can I run Oracle extracted file directly in EDB Postgres?

Accepted Solution

Can I run Oracle extracted file directly in EDB Postgres?

Can I run Oracle extracted file directly in EDB Postgres?

Accepted Solutions (1)

Accepted Solutions (1)

Community Manager
Solution

 

No, the script file extracted from Oracle contains syntax, which is not compatible with EDB Postgres. The Migration Portal Repair handlers make the definitions compatible with EDB Postgres.

 

The following samples display how to make objects compatible in EDB Postgres by using Migration Portal repair handlers:

 

Sample 1: Table extracted from Oracle


Screen Shot 2018-08-04 at 8.28.31 AM.png

Sample 2: EDB Postgres Migration Portal repair handlers are used to make the script compatible.

Screen Shot 2018-08-04 at 8.29.20 AM.png

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