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

Using ALLOW directive to filter table in ora2pg.conf file #1564

Closed sanyamsinghal closed 1 year ago

sanyamsinghal commented 1 year ago

I am trying to export specific tables mentioned with it, for example, there are 3 tables - ACTOR, ADDRESS, and "MY TABLE" in which 2 are normal names, but the third one has a space in between.

I am not able to specify the third one correctly in the conf file. I have tried a couple of ways mentioned below, but nothing worked.

ALLOW        ACTOR,MY SPACE,ADDRESS
ALLOW        ACTOR,'MY SPACE',ADDRESS
ALLOW        ACTOR,"MY SPACE",ADDRESS

what is the right way to do that?

darold commented 1 year ago

Sorry for the response delay. Space and comma are the list separator for ALLOW and EXCLUDE so this will not work but you can use a dot instead as these value are interpreted as regex:

ALLOW        ACTOR,MY.SPACE,ADDRESS