Answer the question
In order to leave comments, you need to log in
Oracle to Postgres?
Good day to all, especially those who used ora2pg.
There is a task of migration from Oracle12 to PostgreSQL12.
Oracle uses 2 own types ARRAY VARCHAR2 and ARRAY NUMBER, I'm trying to convert them into standard PG types VARCHAR[] (_varchar) and NUMERIC[] (_numeric).
With varchar, I did it, the DDL of the table is unloaded, then the data is successfully loaded. But for some reason it doesn't work with numeric[] . The table script is unloaded and loaded into PG correctly, but when loading data, errors pop up about trailing characters, a literal, etc.
I hope someone has already encountered this and can tell you how numeric differs and what additional conf settings are needed for correct data loading.
PS The second question in follow-up, I could not find the data file itself, although it seems to be saved somewhere when exporting.
I will be grateful for any help.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question