Materialized Views 0%
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?
Accepted Solutions (1)
Accepted Solutions (1)
- Report Inappropriate Content
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.
Answers (1)
Answers (1)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Email to a Friend
- Report Inappropriate Content
Hi @hallkbrdz,
The Migration Portal supports the materialized views, could you please share the sample DDL file which is failing at below :
https://enterprisedb.sharefile.com/r-r674d4c712484d2e9
Also, please share the output screenshot for the same.
Regards,
Sudhir