1

I am using ora2pg to migrate schema and data from oracle to postgres database.

Is it possible to export DDL table wise? Currently it's exporting as one file with all the tables.

Udesh Sendanayake
  • 77
  • 2
  • 8
  • 2
    you can split the big file, with csplit (https://stackoverflow.com/questions/11313852/split-one-file-into-multiple-files-based-on-delimiter) using the delimiter: "CREATE TABLE" – mshabou Jan 04 '22 at 09:48

1 Answers1

2

You can not export in separate files. But you can filter what you want to export (table schema etc..) and you can include/ exclude some tables for example.

Have a look to the documentation about ALLOW / EXCLUDE here :https://ora2pg.darold.net/documentation.html#Export-type

cnaimi
  • 484
  • 6
  • 10