-
Notifications
You must be signed in to change notification settings - Fork 341
Ora2Pg Tool Questions
sugain192 edited this page Dec 2, 2021
·
1 revision
Question:
- Which are the stable version to migrate from Oracle to Cloud PostgreSQL
- What objects from Oracle could be migrate to PostgreSQL easily? [Tables, Views, Type (objects) etc.…].
- Were there any known issues when migrating views and its data?
- What are parameters that need to be modified in the ora2pg.conf file.
- Were there issues with adding WHERE clause in the config? Did the WHERE clause filter the data accordingly to the condition to the target. Is there any example of WHERE clause that worked without issues.
- How else we can apply selective data from the source to migrate data to target? (How did ora2pg support that)