search

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
991 stars 342 forks source link

EXCLUDE table does not exclude table from TABLESPACE #1608

Closed EParisot closed 1 year ago

EParisot commented 1 year ago

I needed to exclude a table from export, so EXCLUDE MY_TABLE_NAME, but this table is still exported in TABLESPACE. So crash on TABLESPACE export

darold commented 1 year ago

It works with latest development code, I think the problem is that you are using global allow/exclude definition which will only filter on tablespace name. Use something like that to exclude on table:

EXCLUDE    TABLE[EMPLOYEES]

or at command line:

ora2pg -c config/ora2pg.conf -t TABLESPACE -b tmp -e "TABLE[EMPLOYEES]