T
T
TyuReal2020-09-26 06:18:49
Oracle
TyuReal, 2020-09-26 06:18:49

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 question

Ask a Question

731 491 924 answers to any question