CODEWITHSUNDEEP
postgresqloracle-databasedatabase-migrationora2pg
firstpostcommenter
firstpostcommenter

Reputation: 2931

Double quotes need to be removed and insert statement order need to be fixed

I am using ora2pg to export TABLE and INSERT type from oracle database. https://ora2pg.darold.net/documentation.html#:~:text=Ora2Pg%20consist%20of,QUERY%2C%20KETTLE%2C%20SYNONYM.

I have 2 questions.

The TABLE and INSERT sql statements have double quotes for table and column names but I want to create them without double quotes. Is it possible to configure this in the .conf file?

The INSERT sql file that is generated by ora2pg does not have the sql statements in right order. The parent table data should be inserted first before trying to insert data into child table due to foreign key constraints. But the INSERT sql file generated by ora2pg is not taking this into account so this is causing error because the child table insert statement is present before the parent table. Is this how ora2pg works or am I doing something wrong in the .conf file?

Upvotes: 0

Views: 377

Answers (0)

Related Questions