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.