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

[naveenjul29]

Hi Darold,

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

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]

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

• TABLE
• SEQUENCE
• GRANT
• TABLESPACE
• VIEW
• TRIGGER
• QUERY
• FUNCTION
• PROCEDURE
• PACKAGE
• TYPE
• SYNONYM
• DIRECTORY
• DBLINK
• LOAD
  I mark the issue as needing enhancement.

[naveenjul29]

Thank you Darold

[jkalta]

Hi Darold,
Any update on this enhancement?

[darold]

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

[srinilakshmi]

@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]

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

[srinilakshmi]

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