BP |
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 |
|
|
BP_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
BS_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
DB_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
BP_RECID |
NUMBER |
|
|
|
|
N |
|
|
|
BP_STAMP |
NUMBER |
|
|
|
|
N |
|
|
|
PIECE# |
NUMBER |
|
|
|
|
N |
|
|
|
COPY# |
NUMBER |
|
|
|
|
N |
|
|
|
TAG |
VARCHAR2 |
32 |
32 |
|
|
Y |
|
|
|
DEVICE_TYPE |
VARCHAR2 |
255 |
255 |
|
|
N |
|
|
|
HANDLE |
VARCHAR2 |
1024 |
1024 |
|
|
N |
|
|
|
HANDLE_HASHKEY |
VARCHAR2 |
30 |
30 |
|
|
N |
|
|
|
COMMENTS |
VARCHAR2 |
255 |
255 |
|
|
Y |
|
|
|
MEDIA |
VARCHAR2 |
80 |
80 |
|
|
Y |
|
|
|
MEDIA_POOL |
NUMBER |
|
|
|
|
Y |
|
|
|
CONCUR |
VARCHAR2 |
1 |
1 |
|
|
N |
|
|
|
START_TIME |
DATE |
7 |
|
|
|
N |
|
|
|
COMPLETION_TIME |
DATE |
7 |
|
|
|
N |
|
|
|
STATUS |
VARCHAR2 |
1 |
1 |
|
|
N |
|
|
Total: 18 column(s)
Total: 3 index(s)
|
BP_C_CONCUR |
Not NULL |
Enabled |
|
Not Deferrable |
Immediate |
|
BP_C_STATUS |
Not NULL |
Enabled |
|
Not Deferrable |
Immediate |
|
BP_F1 |
Referential Integrity |
Enabled |
Cascade |
Not Deferrable |
Immediate |
|
BP_P |
Primary Key |
Enabled |
|
Not Deferrable |
Immediate |
|
BP_U1 |
Unique Key |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002813 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002814 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002815 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002816 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002817 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002818 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002819 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002820 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002821 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002822 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002823 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002824 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002825 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002826 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
Total: 19 constraints
Total: 1 table reference(s)
RMAN |
RC_BACKUP_PIECE |
VIEW |
0 |
RMAN |
DBMS_RCVCAT |
PACKAGE BODY |
0 |
RMAN |
DBMS_RCVMAN |
PACKAGE BODY |
0 |
Total: 3 used by reference(s)
CREATE TABLE "RMAN"."BP"
( "BP_KEY" NUMBER NOT NULL ENABLE,
"BS_KEY" NUMBER NOT NULL ENABLE,
"DB_KEY" NUMBER NOT NULL ENABLE,
"BP_RECID" NUMBER NOT NULL ENABLE,
"BP_STAMP" NUMBER NOT NULL ENABLE,
"PIECE#" NUMBER NOT NULL ENABLE,
"COPY#" NUMBER NOT NULL ENABLE,
"TAG" VARCHAR2(32),
"DEVICE_TYPE" VARCHAR2(255) NOT NULL ENABLE,
"HANDLE" VARCHAR2(1024) NOT NULL ENABLE,
"HANDLE_HASHKEY" VARCHAR2(30) NOT NULL ENABLE,
"COMMENTS" VARCHAR2(255),
"MEDIA" VARCHAR2(80),
"MEDIA_POOL" NUMBER,
"CONCUR" VARCHAR2(1) NOT NULL ENABLE,
"START_TIME" DATE NOT NULL ENABLE,
"COMPLETION_TIME" DATE NOT NULL ENABLE,
"STATUS" VARCHAR2(1) NOT NULL ENABLE,
CONSTRAINT "BP_C_STATUS" CHECK (status in ('A','U','D','X')) ENABLE,
CONSTRAINT "BP_C_CONCUR" CHECK (concur in ('Y','N')) ENABLE,
CONSTRAINT "BP_P" PRIMARY KEY ("BP_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 "BP_U1" UNIQUE ("BS_KEY", "BP_RECID", "BP_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 "BP_F1" FOREIGN KEY ("BS_KEY")
REFERENCES "RMAN"."BS" ("BS_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