For Oracle materialized views, I'm getting a 0% sucess rate with a result of ""mv_name" is not a materialized view Hint: Use DROP TABLE to remove a table."
I'm assuming the tool doesn't know what to do with MV's?
Hi hallkbrdz ,
We have verified your assessment and it seems you are using same name of materialized view as name of the table.
Oracle allows same name of table/view/index/materialized view but Postgres doesn’t allow this.
Changing the name of materialized view will make it execute successfully.
Hope this helps.
The Migration Portal supports the materialized views, could you please share the sample DDL file which is failing at below :
Also, please share the output screenshot for the same.