Showing results for 
Search instead for 
Did you mean: 

Materialized Views 0%

Accepted Solution

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)

EDB Team Member

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)

EDB Team Member

Hi @hallkbrdz,


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.




Ask a Question
Top Kudoed Posts