Properties

Name: XDF 
Status: VALID 
Tablespace: TOOLS 
Logging: YES 
Partitioned: NO 
Cached:
Locking enabled: ENABLED 
IOT type:  
Object type:  
Type owner:  
Type:  
Temporary:
Secondary:
Nested: NO 
Buffer pool: DEFAULT 
Row movement: DISABLED 
Index Only Table:  
Minimum % of free space: 10 
Minimum % of udes space:  
Initial transactions:
Max transactions: 255 
Initial extent size, bytes: 65536 
Secondary extent size, bytes:  
Min extents:
Max extents: 2147483645 
% increase in extent:  
Process free list:  
Process free list groups:  
Backee up:
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:
Instances:
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:
SizeBytes: 65536 
Description:  

Columns

Name Type Length Nchar Length Precision Scale NULL Default Description
  XDF_KEY  NUMBER             
  DBINC_KEY  NUMBER             
  XDF_RECID  NUMBER             
  XDF_STAMP  NUMBER             
  FILE#  NUMBER             
  CREATE_SCN  NUMBER             
  TAG  VARCHAR2  32  32         
  INCR_LEVEL  NUMBER             
  CKP_SCN  NUMBER             
  CKP_TIME  DATE           
  ONL_FUZZY  VARCHAR2         
  BCK_FUZZY  VARCHAR2         
  ABS_FUZZY_SCN  NUMBER             
  RCV_FUZZY_SCN  NUMBER             
  RCV_FUZZY_TIME  DATE           
  BLOCKS  NUMBER             
  BLOCK_SIZE  NUMBER             
  DEVICE_TYPE  VARCHAR2  255  255         
  HANDLE  VARCHAR2  1024  1024         
  HANDLE_HASHKEY  VARCHAR2  30  30         
  COMMENTS  VARCHAR2  255  255         
  MEDIA  VARCHAR2  80  80         
  MEDIA_POOL  NUMBER             
  START_TIME  DATE           
  COMPLETION_TIME  DATE           
  STATUS  VARCHAR2         
  KEEP_OPTIONS  NUMBER             
  KEEP_UNTIL  DATE           
Total: 28 column(s)

Indexes

Name Type Unique
  XDF_I_DF_KEY  NORMAL  NONUNIQUE 
  XDF_I_HANDLE_STATUS  NORMAL  NONUNIQUE 
  XDF_P  NORMAL  UNIQUE 
  XDF_U1  NORMAL  UNIQUE 
Total: 4 index(s)

Constraints

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 
Total: 24 constraints

Table References

Name Owner Constraint DELETE_RULE
  DBINC  RMAN  XDF_F1   
Total: 1 table reference(s)

Table used by

Owner Name Type Level
RMAN  RC_PROXY_DATAFILE  VIEW 
RMAN  DBMS_RCVCAT  PACKAGE BODY 
RMAN  DBMS_RCVMAN  PACKAGE BODY 
Total: 3 used by reference(s)

DDL


  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