AL |
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 |
|
|
AL_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
DBINC_KEY |
NUMBER |
|
|
|
|
N |
|
|
|
AL_RECID |
NUMBER |
|
|
|
|
N |
|
|
|
AL_STAMP |
NUMBER |
|
|
|
|
N |
|
|
|
THREAD# |
NUMBER |
|
|
|
|
N |
|
|
|
SEQUENCE# |
NUMBER |
|
|
|
|
N |
|
|
|
LOW_SCN |
NUMBER |
|
|
|
|
N |
|
|
|
LOW_TIME |
DATE |
7 |
|
|
|
N |
|
|
|
NEXT_SCN |
NUMBER |
|
|
|
|
N |
|
|
|
NEXT_TIME |
DATE |
7 |
|
|
|
Y |
|
|
|
FNAME |
VARCHAR2 |
1024 |
1024 |
|
|
Y |
|
|
|
FNAME_HASHKEY |
VARCHAR2 |
20 |
20 |
|
|
Y |
|
|
|
ARCHIVED |
VARCHAR2 |
1 |
1 |
|
|
N |
|
|
|
BLOCKS |
NUMBER |
|
|
|
|
N |
|
|
|
BLOCK_SIZE |
NUMBER |
|
|
|
|
N |
|
|
|
COMPLETION_TIME |
DATE |
7 |
|
|
|
N |
|
|
|
IS_STANDBY |
VARCHAR2 |
1 |
1 |
|
|
Y |
|
|
|
STATUS |
VARCHAR2 |
1 |
1 |
|
|
N |
|
|
|
DICTIONARY_BEGIN |
VARCHAR2 |
3 |
3 |
|
|
Y |
|
|
|
DICTIONARY_END |
VARCHAR2 |
3 |
3 |
|
|
Y |
|
|
Total: 20 column(s)
Total: 4 index(s)
|
AL_C_ARCHIVED |
Not NULL |
Enabled |
|
Not Deferrable |
Immediate |
|
AL_C_IS_STANDBY |
Not NULL |
Enabled |
|
Not Deferrable |
Immediate |
|
AL_C_STATUS |
Not NULL |
Enabled |
|
Not Deferrable |
Immediate |
|
AL_F1 |
Referential Integrity |
Enabled |
Cascade |
Not Deferrable |
Immediate |
|
AL_P |
Primary Key |
Enabled |
|
Not Deferrable |
Immediate |
|
AL_U1 |
Unique Key |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002782 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002783 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002784 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002785 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002786 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002787 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002788 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002789 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002790 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002791 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002792 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002793 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002794 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
|
SYS_C002795 |
Check |
Enabled |
|
Not Deferrable |
Immediate |
Total: 20 constraints
Total: 1 table reference(s)
RMAN |
RC_ARCHIVED_LOG |
VIEW |
0 |
RMAN |
DBMS_RCVCAT |
PACKAGE BODY |
0 |
RMAN |
DBMS_RCVMAN |
PACKAGE BODY |
0 |
Total: 3 used by reference(s)
CREATE TABLE "RMAN"."AL"
( "AL_KEY" NUMBER NOT NULL ENABLE,
"DBINC_KEY" NUMBER NOT NULL ENABLE,
"AL_RECID" NUMBER NOT NULL ENABLE,
"AL_STAMP" NUMBER NOT NULL ENABLE,
"THREAD#" NUMBER NOT NULL ENABLE,
"SEQUENCE#" NUMBER NOT NULL ENABLE,
"LOW_SCN" NUMBER NOT NULL ENABLE,
"LOW_TIME" DATE NOT NULL ENABLE,
"NEXT_SCN" NUMBER NOT NULL ENABLE,
"NEXT_TIME" DATE,
"FNAME" VARCHAR2(1024),
"FNAME_HASHKEY" VARCHAR2(20),
"ARCHIVED" VARCHAR2(1) NOT NULL ENABLE,
"BLOCKS" NUMBER NOT NULL ENABLE,
"BLOCK_SIZE" NUMBER NOT NULL ENABLE,
"COMPLETION_TIME" DATE NOT NULL ENABLE,
"IS_STANDBY" VARCHAR2(1),
"STATUS" VARCHAR2(1) NOT NULL ENABLE,
"DICTIONARY_BEGIN" VARCHAR2(3),
"DICTIONARY_END" VARCHAR2(3),
CONSTRAINT "AL_C_ARCHIVED" CHECK (archived in ('Y','N')) ENABLE,
CONSTRAINT "AL_C_STATUS" CHECK (status in ('A','U','D','X')) ENABLE,
CONSTRAINT "AL_C_IS_STANDBY" CHECK (is_standby in ('Y','N')) ENABLE,
CONSTRAINT "AL_P" PRIMARY KEY ("AL_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 "AL_U1" UNIQUE ("DBINC_KEY", "AL_RECID", "AL_STAMP", "IS_STANDBY")
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 "AL_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