UNI_PLUGGABLE_SET_CHECK

UNI_PLUGGABLE_SET_CHECK contains pluggable check information.

Column	Datatype	NULL	Description
OBJ1_OWNER	VARCHAR2(30)		Owner of object
OBJ1_NAME	VARCHAR2(30)		Object 1
OBJ1_SUBNAME	VARCHAR2(30)		SubObject1Name
OBJ1_TYPE	VARCHAR2(15)		Object Type
TS1_NAME	VARCHAR2(30)		Tablespace containing Object 1
OBJ2_NAME	VARCHAR2(30)		Object Name
OBJ2_SUBNAME	VARCHAR2(30)		SubObject2Name
OBJ2_TYPE	VARCHAR2(15)		Object Type
OBJ2_OWNER	VARCHAR2(30)		Object owner of second object
TS2_NAME	VARCHAR2(30)		Tablespace containing Object 1
CONSTRAINT_NAME	VARCHAR2(30)		Name of dependent constraint
REASON	VARCHAR2(79)		Reason for Pluggable check violation
MESG_ID	NUMBER		The message ID

Note:

1.       It is related with Oracle transportable tablespaces feature. 

2. select * from sys.UNI_PLUGGABLE_SET_CHECK;

OBJ1_OWNER	OBJ1_NAME	OBJ1_TYPE	TS1_NAME	OBJ2_NAME	TS2_NAME	CONSTRAINT_NAME	REASON
WKSYS	WK$_SOURCE_GROUP	TABLE	DRSYS	WK$_SOURCE_GROUP_TL	SYSTEM	SYS_C001745	A table has a constraint on a IOT that is not contained in pluggable set
WKSYS	WK$_SOURCE_GROUP	TABLE	DRSYS	WK$_SOURCE_GROUP_TL	SYSTEM	SYS_C001744	A table has a constraint on a IOT that is not contained in pluggable set
WKSYS	WK$_SOURCE_GROUP	TABLE	DRSYS	WK$_SOURCE_GROUP_TL	SYSTEM	SYS_IOT_TOP_28771	A table has a constraint on a IOT that is not contained in pluggable set
WKSYS	WK$_SOURCE_GROUP	TABLE	DRSYS	WK$_GROUP_DS_MAPPING	SYSTEM	SYS_C001750	A table has a constraint on a IOT that is not contained in pluggable set

Oracle data dictionary views

Oracle dynamic performance views

TS_PITR_OBJECTS_TO_BE_DROPPED

TS_PITR_OBJECTS_TO_BE_DROPPED lists all objects lost as a result of performing tablespace point-in-time recovery. This view applies only to the tablespace point-in-time recovery feature.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	The owner of the object
NAME	VARCHAR2(30)	NOT NULL	The name of the object that will be lost as a result of undergoing tablespace point-in-time recovery
CREATION_TIME	DATE	NOT NULL	Creation timestamp of the object
TABLESPACE_NAME	VARCHAR2(30)		Name of the tablespace containing the object

Note:

1. select * from sys.TS_PITR_OBJECTS_TO_BE_DROPPED;

OWNER	NAME	CREATION_TIME	TABLESPACE_NAME
SYS	I_IND1	2004-03-06 4:32:12 PM	SYSTEM
SYS	I_COBJ#	2004-03-06 4:32:12 PM	SYSTEM
SYS	I_OBJ1	2004-03-06 4:32:12 PM	SYSTEM
SYS	I_PROXY_ROLE_DATA$_2	2004-03-06 4:32:12 PM	SYSTEM
SYS	C_FILE#_BLOCK#	2004-03-06 4:32:12 PM	SYSTEM
SYS	C_OBJ#	2004-03-06 4:32:12 PM	SYSTEM

Oracle data dictionary views

Oracle dynamic performance views

TS_PITR_CHECK

This view, created by catpitr.sql, provides information on any dependencies or restrictions that might prevent tablespace point-in-time recovery from proceeding. This view applies only to the tablespace point-in-time recovery feature.

Column	Datatype	NULL	Description
OBJ1_OWNER	VARCHAR2(30)	NOT NULL	The owner of the object preventing tablespace point-in-time recovery. See the REASON column for details.
OBJ1_NAME	VARCHAR2(30)	NOT NULL	The name of the object preventing tablespace point-in-time recovery
OBJ1_TYPE	VARCHAR2(15)		The object type for the object preventing tablespace point-in-time recovery
OBJ1_SUBNAME	VARCHAR2(30)		Subordinate to OBJ1_NAME
TS1_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the object preventing tablespace point-in-time recovery
OBJ2_NAME	VARCHAR2(30)		The name of a second object which may be preventing tablespace point-in-time recovery. If NULL, object 1 is the only object preventing recovery.
OBJ2_TYPE	VARCHAR2(15)		The object type for the second object (will be NULL if OBJ2_NAME is NULL)
OBJ2_OWNER	VARCHAR2(30)		The owner of the second object (will be NULL if OBJ2_NAME is NULL)
OBJ2_SUBNAME	VARCHAR2(30)		Subordinate to OBJ2_NAME
TS2_NAME	VARCHAR2(30)		Name of the tablespace containing second object which may be preventing tablespace point-in-time recovery (-1 indicates not applicable)
CONSTRAINT_NAME	VARCHAR2(30)		Name of the constraint
REASON	VARCHAR2(78)		Reason why tablespace point-in-time recovery cannot proceed

Note:

1. select * from sys.TS_PITR_CHECK;

Oracle data dictionary views

Oracle dynamic performance views