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 |
No comments:
Post a Comment