adrianrb

Oracle Materialized View - arcpy.MakeTableView_management error

Discussion created by adrianrb on Mar 25, 2014
Hello!

I'm having performance problems with multiversion views.

So, I´ve created Materialized Views (Oracle 11g) over that views and the performance really improved a lot.
But when trying to use that Materialized View in ArcPy (arcpy.MakeTableView_management), I got the error below.

MVM = Materialized View created from Versioned View

> MakeTableView (TEG.MVM_CABO_TRECHO_FIBRA_OPTICA, TEG_CABO_TRECHO_FIBRA_OPTICA_tv)
('ERROR:', ExecuteError ('Failed to execute Parameters are not valid \ nError 000732:.. Input Table:. TEG.MVM_CABO_TRECHO_FIBRA_OPTICA Dataset does not exist or is not supported \ nFailed to execute (MakeTableView) \ n'))


Someone please tell me if Materialized Views are supported in ArcPy?

Adrian

Outcomes