Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Monday, 16 May 2016

ORA-00229

ORA-00229: operation disallowed: already hold snapshot control file enqueue.

Cause: The attempted operation cannot be executed at this time because this process currently holds the snapshot control file enqueue.


Action: Retry the operation after calling cfileUseCurrent to release the snapshot control file enqueue.
Please provide your feedback in the comments section above. Please don't forget to follow.