ora2pg
ora2pg copied to clipboard
Tablespace mapping issue from oracle to postgres
We have two databases on the source Oracle server and we are trying to migrate from Oracle to Postgres using ora2pg. The two databases had the same tablespaces in Oracle but when we try to import from Oracle to Postgres for the second database it says tablespace already exists
Question-1: Is it possible to use the same tablespaces in Postgres for two databases?
Question 2: We tried to change the tablespace names for the second database by mapping the Oracle tablespace name with a different Postgres tablespace in ora2pg.conf file but still the export files are generated with Oracle mapped tablespace, not with the mentioned tablespace. Is it possible to migrate with a different tablespace to Postgres?