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
978 stars 341 forks source link

What is the Maximum size of Byeta in PostgreSQL 15 #1739

Closed satam2007 closed 4 months ago

satam2007 commented 4 months ago

What is the Maximum size of Byeta in PostgreSQL 15.

darold commented 4 months ago

This is not the right place to ask question about PostgreSQL itself and this question is easily self resolved by a search in Google. If your question is more what is the maximum BLOB size that is supported during the migration in bytea to PostgreSQL? You should consider that the data need to be escaped in hexa before being insert to the bytea column, which can reduce de PostgreSQL max size for a bytea by 2. Which mean that it must be lower than 500MB.

If you have such huge BLOB you should export them as PostgreSQL large objects, Ora2Pg have the options to perform that.