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
1.02k stars 343 forks source link

Ora2pg error: FATAL: bad export type using input file option #1057

Open naveenjul29 opened 3 years ago

naveenjul29 commented 3 years ago

Hi Darold,

I am trying to export Materialized views using input file option and got the below error:

Mview Capture

Below query I used:

CREATE MATERIALIZED VIEW "MV_EMP" ("EMPNO", "ENAME", "JOB", "MGR", "HIREDATE", "SAL", "COMM", "DEPTNO") AS SELECT "EMP1"."EMPNO","EMP1"."ENAME","EMP1"."JOB","EMP1"."MGR","EMP1"."HIREDATE","EMP1"."SAL","EMP1"."COMM","EMP1"."DEPTNO" FROM "EMP1";

Can you please let me know what are all the objects we cannot use with input file option?

darold commented 3 years ago

Yes this feature have not been implemented yet. Here are the export type that can be used from a file:

naveenjul29 commented 3 years ago

Thank you Darold

jkalta commented 8 months ago

Hi Darold, Any update on this enhancement?

darold commented 8 months ago

Hi, I have not planned to work on this on the near future.

srinilakshmi commented 1 week ago

@darold I am getting the same error for SHOW_REPORT too.

for SQL Server (scripts).

ora2pg -t SHOW_REPORT --dump_as_json -i ""

How do I get around with this?

darold commented 1 week ago

The -i option can not be used with the SHOW_REPORT action, SHOW_REPORT need a connection to an online database.

srinilakshmi commented 1 week ago

Thank you very much @darold. I have opened another issue 1828 please let me know if you can. TIA