Oracle Online Patching — How To Exclude Tables in a Custom Schema

oracle

Is it possible to exclude specific table objects from online patching? I believe the custom schema in which these tables exist is included in online patching. We are running 11g Enterprise Edition Release 11.2.0.4.0

Best Answer

@Jeff As your database is 12c, you can query dba_objectes and check the the oracle_maintained column, e.g. select OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS, ORACLE_MAINTAINED from dba_objects where OBJECT_NAME='MyObject';. If ORACLE_MAINTAINED is set to 'Y', then your object is likely to be affected by patching, if not it will be ignored.

Related Question