Exclude tables and index restoring about ora2pg HOT 4 CLOSED

If a table name is in the EXCLUDE list, this table with all related indexes and constraint will not be exported at all. Could you explain more the issue you are facing ?

from ora2pg.

I was exporting data with DROP_FKEY and DROP_INDEXES options but it failed on index restoring. So now I want to restore indexes and fkeys only. Is that possible?

I have bunch of EXCLUDE options and they're not taking into account on index restoring/dropping. Would be great if it just mute exception on index creating just like on index dropping.

from ora2pg.

You can always do the following to extract commands from your data output file

grep "CREATE.* INDEX " output.sql > create_indexes.sql
grep "ALTER .* CONSTRAINT " output.sql > create_constraints.sql

using DROP_FKEY and DROP_INDEXES may have added those SQL order at end of the data file.

Is that what you are looking for ?

from ora2pg.

Yes, thank you

I should have thought of that, unfortunately I'm a Windows programmer - Cygwin terminal here I come! 👍

from ora2pg.