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
Solution

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 :

 

https://enterprisedb.sharefile.com/r-r674d4c712484d2e9

 

Also, please share the output screenshot for the same.

 

Regards,

Sudhir

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks