Gilles Darold
Gilles Darold
This is a work in progress, there's no procedure established to achieve what you want to do. It is in my todo list.
Hi Pavel, can you provide a full code example please?
ok, I have never met this syntax so conversion it is not implemented. I will try to do something.
You should use `-o data.sql` Ora2Pg will prefix this filename with the table name.
Are you sure that this table is partitioned? Because I think the partitioning part is commented in your DDL above: ``` /* !50100 PARTITION BY RANGE (a) (PARTITION p0 VALUES...
Can you run Ora2Pg in debug mode (-d) for this table only and reports the query used to extract the data?
You can use `-d -a TBLNAME` to only export the table concerned by the error. What I need is not the error but the query used by Ora2Pg to collect...
Ok, Ora2Pg also extract data from the two column in Oracle: "SNTMESSAGE" and "SntMessage" Does your Oracle table have these two columns? If this is the case and it is...
I depends, if there was no errors on other tables data migration, you can simply run the COPY action on the tables that had an error. See `ALLOW` configuration directive...
The memory used by Ora2Pg is controlled by 3 parameters: - DATA_LIMIT (or option -L) - ORACLE_COPIES (option -J) - PARALLEL_TABLES (option -P) Depending on the number of CPU and...