BCB |
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 |
|
|
BDF_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
BCB_RECID |
NUMBER |
|
|
|
|
N |
|
|
|
BCB_STAMP |
NUMBER |
|
|
|
|
N |
|
|
|
PIECE# |
NUMBER |
|
|
|
|
N |
|
|
|
BLOCK# |
NUMBER |
|
|
|
|
N |
|
|
|
BLOCKS |
NUMBER |
|
|
|
|
N |
|
|
|
CORRUPT_SCN |
NUMBER |
|
|
|
|
Y |
|
|
|
MARKED_CORRUPT |
VARCHAR2 |
1 |
1 |
|
|
N |
|
|
|
CORRUPTION_TYPE |
VARCHAR2 |
9 |
9 |
|
|
Y |
|
|
Total: 9 column(s)
Total: 1 index(s)
|
BCB_F1 |
Referential Integrity |
Enabled |
Cascade |
Not Deferrable |
Immediate |
|
BCB_U1 |
Unique Key |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002974 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002975 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002976 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002977 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002978 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002979 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002980 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
Total: 9 constraints
Total: 1 table reference(s)
RMAN |
RC_BACKUP_CORRUPTION |
VIEW |
0 |
RMAN |
DBMS_RCVCAT |
PACKAGE BODY |
0 |
Total: 2 used by reference(s)
CREATE TABLE "RMAN"."BCB"
( "BDF_KEY" NUMBER NOT NULL ENABLE,
"BCB_RECID" NUMBER NOT NULL ENABLE,
"BCB_STAMP" NUMBER NOT NULL ENABLE,
"PIECE#" NUMBER NOT NULL ENABLE,
"BLOCK#" NUMBER NOT NULL ENABLE,
"BLOCKS" NUMBER NOT NULL ENABLE,
"CORRUPT_SCN" NUMBER,
"MARKED_CORRUPT" VARCHAR2(1) NOT NULL ENABLE,
"CORRUPTION_TYPE" VARCHAR2(9),
CONSTRAINT "BCB_U1" UNIQUE ("BDF_KEY", "BCB_RECID", "BCB_STAMP")
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 "BCB_F1" FOREIGN KEY ("BDF_KEY")
REFERENCES "RMAN"."BDF" ("BDF_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