CKP |
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 |
|
|
CKP_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
CKP_SCN |
NUMBER |
|
|
|
|
N |
|
|
|
CKP_TIME |
DATE |
7 |
|
|
|
Y |
|
|
|
CKP_CF_SEQ |
NUMBER |
|
|
|
|
N |
|
|
|
CF_CREATE_TIME |
DATE |
7 |
|
|
|
N |
|
|
|
DBINC_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
CKP_TYPE |
VARCHAR2 |
7 |
7 |
|
|
N |
|
|
|
CKP_DB_STATUS |
VARCHAR2 |
7 |
7 |
|
|
Y |
|
|
|
RESYNC_TIME |
DATE |
7 |
|
|
|
N |
|
|
|
HIGH_DF_RECID |
NUMBER |
|
|
|
|
N |
|
|
Total: 10 column(s)
Total: 2 index(s)
|
CKP_C_TYPE |
Not NULL |
Enabled |
|
Not Deferrable |
Immediate |
|
CKP_F1 |
Referential Integrity |
Enabled |
Cascade |
Not Deferrable |
Immediate |
|
CKP_P |
Primary Key |
Enabled |
|
Not Deferrable |
Immediate |
|
CKP_U1 |
Unique Key |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002692 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002693 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002694 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002695 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002696 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002697 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002698 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002699 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
Total: 12 constraints
Total: 4 referenced table(s)
Total: 1 table reference(s)
RMAN |
RC_RESYNC |
VIEW |
0 |
RMAN |
RC_CHECKPOINT |
VIEW |
0 |
RMAN |
DBMS_RCVCAT |
PACKAGE BODY |
0 |
RMAN |
DBMS_RCVMAN |
PACKAGE BODY |
0 |
Total: 4 used by reference(s)
CREATE TABLE "RMAN"."CKP"
( "CKP_KEY" NUMBER NOT NULL ENABLE,
"CKP_SCN" NUMBER NOT NULL ENABLE,
"CKP_TIME" DATE,
"CKP_CF_SEQ" NUMBER NOT NULL ENABLE,
"CF_CREATE_TIME" DATE NOT NULL ENABLE,
"DBINC_KEY" NUMBER NOT NULL ENABLE,
"CKP_TYPE" VARCHAR2(7) NOT NULL ENABLE,
"CKP_DB_STATUS" VARCHAR2(7),
"RESYNC_TIME" DATE NOT NULL ENABLE,
"HIGH_DF_RECID" NUMBER NOT NULL ENABLE,
CONSTRAINT "CKP_C_TYPE" CHECK (ckp_type in ('FULL', 'PARTIAL')) ENABLE,
CONSTRAINT "CKP_P" PRIMARY KEY ("CKP_KEY")
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 "CKP_U1" UNIQUE ("DBINC_KEY", "CKP_SCN", "CKP_TYPE", "CKP_CF_SEQ", "CF_CREATE_TIME")
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 "CKP_F1" FOREIGN KEY ("DBINC_KEY")
REFERENCES "RMAN"."DBINC" ("DBINC_KEY") 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