Name: | XDF |
Status: | VALID |
Tablespace: | TOOLS |
Logging: | YES |
Partitioned: | NO |
Cached: | N |
Locking enabled: | ENABLED |
IOT type: | |
Object type: | |
Type owner: | |
Type: | |
Temporary: | N |
Secondary: | N |
Nested: | NO |
Buffer pool: | DEFAULT |
Row movement: | DISABLED |
Index Only Table: | |
Minimum % of free space: | 10 |
Minimum % of udes space: | |
Initial transactions: | 1 |
Max transactions: | 255 |
Initial extent size, bytes: | 65536 |
Secondary extent size, bytes: | |
Min extents: | 1 |
Max extents: | 2147483645 |
% increase in extent: | |
Process free list: | |
Process free list groups: | |
Backee up: | N |
Rows: | |
Used blocks: | |
Empty blocks: | |
Average free space: | |
Chained rows: | |
Average row length: | |
Average freespace on a freelist: | |
Blocks on a freelist: | |
Threds per instance: | 1 |
Instances: | 1 |
Sample size: | |
Last analysed: | |
Global statistics: | NO |
User statistics: | NO |
Duration: | |
Skip corrupt blocks: | DISABLED |
Monitoring: | NO |
Cluster owner: | |
Dependencies: | DISABLED |
SizeMB: | 0.06 |
Extents: | 1 |
SizeBytes: | 65536 |
Description: |
Name | Type | Length | Nchar Length | Precision | Scale | NULL | Default | Description | |
|
XDF_KEY | NUMBER | N | ||||||
|
DBINC_KEY | NUMBER | N | ||||||
|
XDF_RECID | NUMBER | N | ||||||
|
XDF_STAMP | NUMBER | N | ||||||
|
FILE# | NUMBER | N | ||||||
|
CREATE_SCN | NUMBER | N | ||||||
|
TAG | VARCHAR2 | 32 | 32 | Y | ||||
|
INCR_LEVEL | NUMBER | Y | ||||||
|
CKP_SCN | NUMBER | N | ||||||
|
CKP_TIME | DATE | 7 | N | |||||
|
ONL_FUZZY | VARCHAR2 | 1 | 1 | N | ||||
|
BCK_FUZZY | VARCHAR2 | 1 | 1 | N | ||||
|
ABS_FUZZY_SCN | NUMBER | Y | ||||||
|
RCV_FUZZY_SCN | NUMBER | Y | ||||||
|
RCV_FUZZY_TIME | DATE | 7 | Y | |||||
|
BLOCKS | NUMBER | N | ||||||
|
BLOCK_SIZE | NUMBER | N | ||||||
|
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 | ||||||
|
START_TIME | DATE | 7 | N | |||||
|
COMPLETION_TIME | DATE | 7 | N | |||||
|
STATUS | VARCHAR2 | 1 | 1 | N | ||||
|
KEEP_OPTIONS | NUMBER | Y | ||||||
|
KEEP_UNTIL | DATE | 7 | Y |
Name | Type | Unique | |
|
XDF_I_DF_KEY | NORMAL | NONUNIQUE |
|
XDF_I_HANDLE_STATUS | NORMAL | NONUNIQUE |
|
XDF_P | NORMAL | UNIQUE |
|
XDF_U1 | NORMAL | UNIQUE |
Name | Type | Status | Delete rule | Defferable | Deffered | |
|
SYS_C002934 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002935 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002936 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002937 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002938 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002939 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002940 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002941 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002942 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002943 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002944 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002945 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002946 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002947 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002948 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002949 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002950 | Check | Enabled | Not Deferrable | Immediate | |
|
SYS_C002951 | Check | Enabled | Not Deferrable | Immediate | |
|
XDF_C_BCK_FUZZY | Not NULL | Enabled | Not Deferrable | Immediate | |
|
XDF_C_ONL_FUZZY | Not NULL | Enabled | Not Deferrable | Immediate | |
|
XDF_C_STATUS | Not NULL | Enabled | Not Deferrable | Immediate | |
|
XDF_F1 | Referential Integrity | Enabled | Cascade | Not Deferrable | Immediate |
|
XDF_P | Primary Key | Enabled | Not Deferrable | Immediate | |
|
XDF_U1 | Unique Key | Enabled | Not Deferrable | Immediate |
Name | Owner | Constraint | DELETE_RULE | |
|
DBINC | RMAN | XDF_F1 |
Owner | Name | Type | Level |
RMAN | RC_PROXY_DATAFILE | VIEW | 0 |
RMAN | DBMS_RCVCAT | PACKAGE BODY | 0 |
RMAN | DBMS_RCVMAN | PACKAGE BODY | 0 |
CREATE TABLE "RMAN"."XDF"
( "XDF_KEY" NUMBER NOT NULL ENABLE,
"DBINC_KEY" NUMBER NOT NULL ENABLE,
"XDF_RECID" NUMBER NOT NULL ENABLE,
"XDF_STAMP" NUMBER NOT NULL ENABLE,
"FILE#" NUMBER NOT NULL ENABLE,
"CREATE_SCN" NUMBER NOT NULL ENABLE,
"TAG" VARCHAR2(32),
"INCR_LEVEL" NUMBER,
"CKP_SCN" NUMBER NOT NULL ENABLE,
"CKP_TIME" DATE NOT NULL ENABLE,
"ONL_FUZZY" VARCHAR2(1) NOT NULL ENABLE,
"BCK_FUZZY" VARCHAR2(1) NOT NULL ENABLE,
"ABS_FUZZY_SCN" NUMBER,
"RCV_FUZZY_SCN" NUMBER,
"RCV_FUZZY_TIME" DATE,
"BLOCKS" NUMBER NOT NULL ENABLE,
"BLOCK_SIZE" NUMBER NOT NULL ENABLE,
"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,
"START_TIME" DATE NOT NULL ENABLE,
"COMPLETION_TIME" DATE NOT NULL ENABLE,
"STATUS" VARCHAR2(1) NOT NULL ENABLE,
"KEEP_OPTIONS" NUMBER,
"KEEP_UNTIL" DATE,
CONSTRAINT "XDF_C_STATUS" CHECK (status in ('A','U','D','X')) ENABLE,
CONSTRAINT "XDF_C_ONL_FUZZY" CHECK (onl_fuzzy in ('Y','N')) ENABLE,
CONSTRAINT "XDF_C_BCK_FUZZY" CHECK (bck_fuzzy in ('Y','N')) ENABLE,
CONSTRAINT "XDF_P" PRIMARY KEY ("XDF_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 "XDF_U1" UNIQUE ("DBINC_KEY", "XDF_RECID", "XDF_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 "XDF_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"
See Also
List of tables