bad table creation operator

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

bad table creation operator #1696

Closed tbw777 closed 5 months ago

tbw777 commented 9 months ago

FDW_output.sql:

-- Generated by Ora2Pg, the Oracle database Schema converter, version 24.1
-- Copyright 2000-2023 Gilles DAROLD. All rights reserved.
-- DATASOURCE: <hidden>

CREATE FOREIGN  TABLE  (
) SERVER  OPTIONS( table '', readonly 'true');

[42601] ERROR: syntax error at or near "("

All other CREATE blocks has equal syntax errors

darold commented 8 months ago

Hi, I'm not able to reproduce the problem with Oracle export. Are you using latest development code and can you tell me which RDBMS is the source database?

tbw777 commented 8 months ago

I'm using latest version in docker image named as georgmoser/ora2pg

darold commented 5 months ago

Not reproducible without docker I guess the issue is related to docker execution of ora2pg.