BS |
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 |
|
|
BS_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
DB_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
BS_RECID |
NUMBER |
|
|
|
|
Y |
|
|
|
BS_STAMP |
NUMBER |
|
|
|
|
Y |
|
|
|
SET_STAMP |
NUMBER |
|
|
|
|
N |
|
|
|
SET_COUNT |
NUMBER |
|
|
|
|
N |
|
|
|
BCK_TYPE |
VARCHAR2 |
1 |
1 |
|
|
Y |
|
|
|
INCR_LEVEL |
NUMBER |
|
|
|
|
Y |
|
|
|
PIECES |
NUMBER |
|
|
|
|
N |
|
|
|
START_TIME |
DATE |
7 |
|
|
|
Y |
|
|
|
COMPLETION_TIME |
DATE |
7 |
|
|
|
Y |
|
|
|
STATUS |
VARCHAR2 |
1 |
1 |
|
|
Y |
|
|
|
CONTROLFILE_INCLUDED |
VARCHAR2 |
7 |
7 |
|
|
Y |
|
|
|
INPUT_FILE_SCAN_ONLY |
VARCHAR2 |
3 |
3 |
|
|
Y |
|
|
|
KEEP_OPTIONS |
NUMBER |
|
|
|
|
Y |
|
|
|
KEEP_UNTIL |
DATE |
7 |
|
|
|
Y |
|
|
Total: 16 column(s)
Total: 2 index(s)
Total: 11 constraints
Total: 5 referenced table(s)
Total: 1 table reference(s)
RMAN |
RC_BACKUP_SET |
VIEW |
0 |
RMAN |
RC_BACKUP_PIECE |
VIEW |
0 |
RMAN |
RC_BACKUP_DATAFILE |
VIEW |
0 |
RMAN |
RC_BACKUP_CONTROLFILE |
VIEW |
0 |
RMAN |
RC_BACKUP_SPFILE |
VIEW |
0 |
RMAN |
RC_BACKUP_REDOLOG |
VIEW |
0 |
RMAN |
RC_BACKUP_CORRUPTION |
VIEW |
0 |
RMAN |
DBMS_RCVCAT |
PACKAGE BODY |
0 |
RMAN |
DBMS_RCVMAN |
PACKAGE BODY |
0 |
Total: 9 used by reference(s)
CREATE TABLE "RMAN"."BS"
( "BS_KEY" NUMBER NOT NULL ENABLE,
"DB_KEY" NUMBER NOT NULL ENABLE,
"BS_RECID" NUMBER,
"BS_STAMP" NUMBER,
"SET_STAMP" NUMBER NOT NULL ENABLE,
"SET_COUNT" NUMBER NOT NULL ENABLE,
"BCK_TYPE" VARCHAR2(1),
"INCR_LEVEL" NUMBER,
"PIECES" NUMBER NOT NULL ENABLE,
"START_TIME" DATE,
"COMPLETION_TIME" DATE,
"STATUS" VARCHAR2(1),
"CONTROLFILE_INCLUDED" VARCHAR2(7),
"INPUT_FILE_SCAN_ONLY" VARCHAR2(3),
"KEEP_OPTIONS" NUMBER,
"KEEP_UNTIL" DATE,
CONSTRAINT "BS_C_BCK_TYPE" CHECK (bck_type in ('D','I','L')) ENABLE,
CONSTRAINT "BS_C_INCR_LEVEL" CHECK (incr_level in (0,1,2,3,4)) ENABLE,
CONSTRAINT "BS_C_CONTROLFILE_INCLUDED" CHECK (controlfile_included in
('NONE','BACKUP','STANDBY')) ENABLE,
CONSTRAINT "BS_P" PRIMARY KEY ("BS_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 "BS_U2" UNIQUE ("DB_KEY", "SET_STAMP", "SET_COUNT")
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 "BS_F1" FOREIGN KEY ("DB_KEY")
REFERENCES "RMAN"."DB" ("DB_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