We have Oracle 11.2.0.2 database that runs on IBM AIX 7.1.
Trying to drop and recreate 3 independent materialized views mv1,mv2,mv3 simultaneously by using an SSIS package daily manner. Normally it works, but some days we get the following error
Executing the query "DROP MATERIALIZED VIEW MV1" failed with the following error: "ORA-04021: timeout occurred while waiting to lock object ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
MV1 is having partions and subpartitions.
Can anybody help.
Regards,
Sreeraj