topic Oracle Materialized View - arcpy.MakeTableView_management error in Python Questions https://community.esri.com/t5/python-questions/oracle-materialized-view-arcpy-maketableview/m-p/350592#M27501 <HTML><HEAD></HEAD><BODY><SPAN>Hello!</SPAN><BR /><BR /><SPAN>I'm having performance problems with multiversion views.</SPAN><BR /><BR /><SPAN>So, I´ve created Materialized Views (Oracle 11g) over that views and the performance really improved a lot.</SPAN><BR /><SPAN>But when trying to use that Materialized View in ArcPy (arcpy.MakeTableView_management), I got the error below.</SPAN><BR /><BR /><SPAN>MVM = Materialized View created from Versioned View</SPAN><BR /><BR /><SPAN>&gt; MakeTableView (TEG.MVM_CABO_TRECHO_FIBRA_OPTICA, TEG_CABO_TRECHO_FIBRA_OPTICA_tv)</SPAN><BR /><SPAN>('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'))</SPAN><BR /><BR /><BR /><SPAN>Someone please tell me if Materialized Views are supported in ArcPy?</SPAN><BR /><BR /><SPAN>Adrian</SPAN></BODY></HTML> Tue, 25 Mar 2014 13:44:25 GMT Adrian_R_Barbosa 2014-03-25T13:44:25Z Oracle Materialized View - arcpy.MakeTableView_management error https://community.esri.com/t5/python-questions/oracle-materialized-view-arcpy-maketableview/m-p/350592#M27501 <HTML><HEAD></HEAD><BODY><SPAN>Hello!</SPAN><BR /><BR /><SPAN>I'm having performance problems with multiversion views.</SPAN><BR /><BR /><SPAN>So, I´ve created Materialized Views (Oracle 11g) over that views and the performance really improved a lot.</SPAN><BR /><SPAN>But when trying to use that Materialized View in ArcPy (arcpy.MakeTableView_management), I got the error below.</SPAN><BR /><BR /><SPAN>MVM = Materialized View created from Versioned View</SPAN><BR /><BR /><SPAN>&gt; MakeTableView (TEG.MVM_CABO_TRECHO_FIBRA_OPTICA, TEG_CABO_TRECHO_FIBRA_OPTICA_tv)</SPAN><BR /><SPAN>('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'))</SPAN><BR /><BR /><BR /><SPAN>Someone please tell me if Materialized Views are supported in ArcPy?</SPAN><BR /><BR /><SPAN>Adrian</SPAN></BODY></HTML> Tue, 25 Mar 2014 13:44:25 GMT https://community.esri.com/t5/python-questions/oracle-materialized-view-arcpy-maketableview/m-p/350592#M27501 Adrian_R_Barbosa 2014-03-25T13:44:25Z