postgresqloracle-databaseora2pg

Configuration of Ora2pg in TABLE directive

#I am using ora2pg tool for database migration(oracle to PostgreSQL). I have to limit some tables from export, For that i have made changes accordingly in ora2pg config file(add table name in tabledirective). But when i execute this ora2pg config file it will export all object for me(Not justte single table specified in TABLE directive).

There are no conflicts with EXCLUDE directive. Any idea on this problem?

TABLE ALERT_HEADER 
#EXCLUDE    OTHER_TABLES
NO_EXCLUDED_TABLE   0
Solution 
  • ALLOW ALERT_HEADER

    got it, it shuld use ALLOW directive.