DF |
VALID |
TOOLS |
YES |
NO |
N |
ENABLED |
|
|
|
|
N |
N |
NO |
DEFAULT |
DISABLED |
|
10 |
|
1 |
255 |
65536 |
|
1 |
2147483645 |
|
|
|
N |
|
|
|
|
|
|
|
|
1 |
1 |
|
|
NO |
NO |
|
DISABLED |
NO |
|
DISABLED |
0.06 |
1 |
65536 |
|
|
DBINC_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
FILE# |
NUMBER |
|
|
|
|
N |
|
|
|
CREATE_SCN |
NUMBER |
|
|
|
|
N |
|
|
|
CREATE_TIME |
DATE |
7 |
|
|
|
Y |
|
|
|
TS# |
NUMBER |
|
|
|
|
N |
|
|
|
TS_CREATE_SCN |
NUMBER |
|
|
|
|
N |
|
|
|
BLOCK_SIZE |
NUMBER |
|
|
|
|
N |
|
|
|
CLONE_FNAME |
VARCHAR2 |
1024 |
1024 |
|
|
Y |
|
|
|
DROP_SCN |
NUMBER |
|
|
|
|
Y |
|
|
|
DROP_TIME |
DATE |
7 |
|
|
|
Y |
|
|
|
STOP_SCN |
NUMBER |
|
|
|
|
Y |
|
|
|
STOP_TIME |
DATE |
7 |
|
|
|
Y |
|
|
|
READ_ONLY |
NUMBER |
|
|
|
|
N |
|
|
|
RFILE# |
NUMBER |
|
|
|
|
Y |
|
|
Total: 14 column(s)
Total: 3 index(s)
|
DF_F1 |
Referential Integrity |
Enabled |
Cascade |
Not Deferrable |
Immediate |
|
DF_P |
Primary Key |
Enabled |
|
Not Deferrable |
Immediate |
|
DF_U1 |
Unique Key |
Enabled |
|
Not Deferrable |
Immediate |
|
DF_U2 |
Unique Key |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002720 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002721 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002722 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002723 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002724 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002725 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002726 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
Total: 11 constraints
Total: 1 referenced table(s)
Total: 1 table reference(s)
RMAN |
RC_DATAFILE |
VIEW |
0 |
RMAN |
DBMS_RCVCAT |
PACKAGE BODY |
0 |
RMAN |
DBMS_RCVMAN |
PACKAGE BODY |
0 |
Total: 3 used by reference(s)
CREATE TABLE "RMAN"."DF"
( "DBINC_KEY" NUMBER NOT NULL ENABLE,
"FILE#" NUMBER NOT NULL ENABLE,
"CREATE_SCN" NUMBER NOT NULL ENABLE,
"CREATE_TIME" DATE,
"TS#" NUMBER NOT NULL ENABLE,
"TS_CREATE_SCN" NUMBER NOT NULL ENABLE,
"BLOCK_SIZE" NUMBER NOT NULL ENABLE,
"CLONE_FNAME" VARCHAR2(1024),
"DROP_SCN" NUMBER,
"DROP_TIME" DATE,
"STOP_SCN" NUMBER,
"STOP_TIME" DATE,
"READ_ONLY" NUMBER NOT NULL ENABLE,
"RFILE#" NUMBER,
CONSTRAINT "DF_P" PRIMARY KEY ("DBINC_KEY", "FILE#", "CREATE_SCN")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TOOLS" ENABLE,
CONSTRAINT "DF_U1" UNIQUE ("DBINC_KEY", "FILE#", "DROP_SCN")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TOOLS" ENABLE,
CONSTRAINT "DF_U2" UNIQUE ("DBINC_KEY", "TS#", "TS_CREATE_SCN", "FILE#")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TOOLS" ENABLE,
CONSTRAINT "DF_F1" FOREIGN KEY ("DBINC_KEY", "TS#", "TS_CREATE_SCN")
REFERENCES "RMAN"."TS" ("DBINC_KEY", "TS#", "CREATE_SCN") ON DELETE CASCADE ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TOOLS"
List of tables