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

Error during count of the rows #1605

Closed franxav06 closed 1 year ago

franxav06 commented 1 year ago

Good morning I have executed the following command

ora2pg -t TEST -c config/ora2pg.conf --count_rows > migration_diff_count.txt

and it ends in error with the following error message :

FATAL: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <> indicator at char 21 in 'SELECT COUNT() FROM <*>ADOPTION_ALLOWANCES')

The string <*> in the query is at the origin of the problem

Thanks in advance for your help

Francesco DI TULLO

franxav06 commented 1 year ago

Hello solved with

SQL> alter system set pga_aggregate_limit=0 scope=both;