DBINC |
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 |
|
|
|
DB_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
DB_NAME |
VARCHAR2 |
8 |
8 |
|
|
N |
|
|
|
RESET_SCN |
NUMBER |
|
|
|
|
N |
|
|
|
RESET_TIME |
DATE |
7 |
|
|
|
N |
|
|
|
PARENT_DBINC_KEY |
NUMBER |
|
|
|
|
Y |
|
|
|
CF_CREATE_TIME |
DATE |
7 |
|
|
|
Y |
|
|
|
CKP_SCN |
NUMBER |
|
|
|
|
N |
0 |
|
|
FULL_CKP_CF_SEQ |
NUMBER |
|
|
|
|
N |
0 |
|
|
JOB_CKP_CF_SEQ |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_TS_RECID |
NUMBER |
|
|
|
|
Y |
|
|
|
HIGH_DF_RECID |
NUMBER |
|
|
|
|
Y |
|
|
|
HIGH_RT_RECID |
NUMBER |
|
|
|
|
Y |
|
|
|
HIGH_ORL_RECID |
NUMBER |
|
|
|
|
Y |
|
|
|
HIGH_OFFR_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_RLH_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_AL_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_BS_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_BP_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_BDF_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_CDF_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_BRL_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_BCB_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_CCB_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_DO_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_PC_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
|
HIGH_BSF_RECID |
NUMBER |
|
|
|
|
N |
0 |
|
Total: 27 column(s)
Total: 2 index(s)
Total: 24 constraints
Total: 12 referenced table(s)
Total: 1 table reference(s)
RMAN |
RC_DATABASE |
VIEW |
0 |
RMAN |
RC_DATABASE_INCARNATION |
VIEW |
0 |
RMAN |
RC_RESYNC |
VIEW |
0 |
RMAN |
RC_CHECKPOINT |
VIEW |
0 |
RMAN |
RC_TABLESPACE |
VIEW |
0 |
RMAN |
RC_DATAFILE |
VIEW |
0 |
RMAN |
RC_REDO_THREAD |
VIEW |
0 |
RMAN |
RC_REDO_LOG |
VIEW |
0 |
RMAN |
RC_LOG_HISTORY |
VIEW |
0 |
RMAN |
RC_ARCHIVED_LOG |
VIEW |
0 |
RMAN |
RC_BACKUP_DATAFILE |
VIEW |
0 |
RMAN |
RC_BACKUP_CONTROLFILE |
VIEW |
0 |
RMAN |
RC_DATAFILE_COPY |
VIEW |
0 |
RMAN |
RC_CONTROLFILE_COPY |
VIEW |
0 |
RMAN |
RC_BACKUP_REDOLOG |
VIEW |
0 |
RMAN |
RC_BACKUP_CORRUPTION |
VIEW |
0 |
RMAN |
RC_COPY_CORRUPTION |
VIEW |
0 |
RMAN |
RC_OFFLINE_RANGE |
VIEW |
0 |
RMAN |
RC_STORED_SCRIPT |
VIEW |
0 |
RMAN |
RC_PROXY_DATAFILE |
VIEW |
0 |
RMAN |
RC_PROXY_CONTROLFILE |
VIEW |
0 |
RMAN |
DBMS_RCVCAT |
PACKAGE BODY |
0 |
RMAN |
DBMS_RCVMAN |
PACKAGE BODY |
0 |
Total: 23 used by reference(s)
CREATE TABLE "RMAN"."DBINC"
( "DBINC_KEY" NUMBER NOT NULL ENABLE,
"DB_KEY" NUMBER NOT NULL ENABLE,
"DB_NAME" VARCHAR2(8) NOT NULL ENABLE,
"RESET_SCN" NUMBER NOT NULL ENABLE,
"RESET_TIME" DATE NOT NULL ENABLE,
"PARENT_DBINC_KEY" NUMBER,
"CF_CREATE_TIME" DATE,
"CKP_SCN" NUMBER DEFAULT 0 NOT NULL ENABLE,
"FULL_CKP_CF_SEQ" NUMBER DEFAULT 0 NOT NULL ENABLE,
"JOB_CKP_CF_SEQ" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_TS_RECID" NUMBER,
"HIGH_DF_RECID" NUMBER,
"HIGH_RT_RECID" NUMBER,
"HIGH_ORL_RECID" NUMBER,
"HIGH_OFFR_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_RLH_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_AL_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BS_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BP_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BDF_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_CDF_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BRL_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BCB_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_CCB_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_DO_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_PC_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BSF_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
CONSTRAINT "DBINC_P" PRIMARY KEY ("DBINC_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 "DBINC_U1" UNIQUE ("DB_KEY", "RESET_SCN", "RESET_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 "DBINC_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