![]() You are receiving this because you authored the thread. I guess that in this case there should be an error message before all the \N error messages. I have found your slides at ora2pg-performances.pdf ()ĭe : Gilles Darold : mercredi, 1 mars 2023 10:57 Now I have to install PENTAHO_KETTLE and see which interactions are possible with ORA2PG. I'm very new into the migration from Oracle to Postgres, so it took me sometime to ![]() Yes, in order to see it the load need to be stopped immediately after …. ![]() You are receiving this because you authored the thread.Message ID: for your answer Reply to this email directly, view it on GitHub, or unsubscribe. I can not reproduce this issue, can you post the Oracle description of the table? Are you importing data from files using psql or are you using a direct data import with ora2pg? The error has no incidence on the export so we can just ignore it. À : darold/ora2pg : Francesco Di Tullo Author : Re: Problem with \N value during import (Issue #1594) This error can appears when LOB chunk size is different from default 8192. Pensez à l'environnement avant d'imprimer !ĭe : Gilles Darold : jeudi, 23 février 2023 22:58 With the \N value without problem, but I cannot when it's a partition of a table What I can tell you for sure, is that I don't have the problem with not partitioned tables, I can load millions of rows It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database. I cannot post the description of the table, it's highly confidential. NAME Ora2Pg - Oracle to PostgreSQL database schema converter DESCRIPTION Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL. I have the problem both using psql (on Linux and Windows) and importing directly with ora2pg. Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |