Ora2pg IMPORTING DATA ERROR: out of shared memory

darold / ora2pg

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.

http://www.ora2pg.com/

GNU General Public License v3.0

978 stars 341 forks source link

Ora2pg IMPORTING DATA ERROR: out of shared memory #1746

Closed avmindestroy closed 3 months ago

avmindestroy commented 3 months ago

Hi,

[2024-03-11 08:58:07] [========================>] 2756/2756 tables (100.0%) end of scanning. FATAL: ERROR: out of shared memory HINT: You might need to increase max_locks_per_transaction. Aborting export...

darold commented 3 months ago

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 RAM you have you might adjust these values.

avmindestroy commented 3 months ago

The following error occurs en masse when importing a database

avmindestroy commented 3 months ago

hello The following error occurs en masse when importing a database

darold commented 3 months ago

You need to use another encoding.