Is there any option to skip a specific object in the show_report to avoid or2pg encountering out of memory

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

http://www.ora2pg.com/

GNU General Public License v3.0

1.02k stars 343 forks source link

Is there any option to skip a specific object in the show_report to avoid or2pg encountering out of memory #1572

Closed vthiyya closed 1 year ago

vthiyya commented 1 year ago

Hi Darold,

We are having an issue where or2pg has been failing with out of memory when running assessment against couple of views.

We would like to skip only those views. We tried 'exclude' but it seems to be only for the copy data feature.

Do we have any option to perform the same ?

Regards, Vishal

darold commented 1 year ago

Normally the following should work to exclude some view from the export:

EXCLUDE     VIEW[VNAME1 VNAME2 VNAME3 ...]

Do you have the same OOM when you are exporting views?