Issue exporting Materialized view using script

[srinilakshmi]

Hi Darold,

I am working on migrating SQL Server scripts to PostgreSQL using windows version of Ora2PG with scripts migration (offline due to restrictions in our company).

I am having issue with exporting Materialized views, getting an error. please find the attached screenshot

and when get chance can you look at the other issue we had conversation https://github.com/darold/ora2pg/issues/1828

Any help for the above is really helpful and I am desperately need help with these.

TIA

[wisdomonezxy]

only a test

[srinilakshmi]

Not following.

[srinilakshmi]

@darold and @wisdomonezxy Can someone explain what it means by test? Is that functionality only available in testing?

[darold]

@srinilakshmi, you write "not following" so I have understood that this issues was discarded.

I have done some work recently to better support migration of input DDL script for SQL Server but there's less possible translation than for Oracle. Anyway materialized view are not supported yet. If you can post DDL samples I can try to implements it.

[srinilakshmi]

@darold sorry for the confusion.

Here is the sample Materailized view for Oracle db in DDL script. Please let me know.

CREATE MATERIALIZED VIEW "MD_SAMPLE_VIEW" ("PROJECT_ID", "CONNECTION_ID", "CONNECTION_NAME") SEGMENT CREATION DEFERRED ORGANIZATION HEAP PCFTREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING NO INMEMORY BUILD IMMEDIATE USING INDEX REFRESH FORCE ON DEMAND USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONMSTRAINTS DISABLE ON QUERY COPUTATION DISABLE QUERY REWRITE AS SELECT PROJECT_ID, CONNECTION_ID, CONNECTION_NAME from MD_REGEX_SCHEMA_MVIEW group by PROJECT_ID, CONNECTION_ID, CONNECTION_NAME;

COMMENT ON MATERIALIZED VIEW "MD_SAMPLE_VIEW" IS 'sample materialized view';