search

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
991 stars 342 forks source link

Apply BLOB_LIMIT to Oracle type CLOB #1601

Closed omebarki closed 1 year ago

omebarki commented 1 year ago

CLOBs also should be treated as BLOBs because they are big and can cause memory overloading

darold commented 1 year ago

Sorry for the delay but I was not sure of the right way to add such feature. I have modified your patch to be able to control the feature with a configuration directive and keep the actual behavior.

    CLOB_AS_BLOB
        Apply same behavior on CLOB than BLOB with BLOB_LIMIT setting. This
        could be useful if you have large CLOB data.

See commit 0369208