Properties

Name:	CDF
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:

Columns

	Name	Type	Length	Nchar Length	Precision	Scale	NULL	Default	Description
	CDF_KEY	NUMBER					N
	DBINC_KEY	NUMBER					N
	CDF_RECID	NUMBER					N
	CDF_STAMP	NUMBER					N
	FILE#	NUMBER					N
	CREATE_SCN	NUMBER					N
	FNAME	VARCHAR2	1024	1024			N
	FNAME_HASHKEY	VARCHAR2	20	20			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
	COMPLETION_TIME	DATE	7				N
	STATUS	VARCHAR2	1	1			N
	KEEP_OPTIONS	NUMBER					Y
	KEEP_UNTIL	DATE	7				Y
	SCANNED	VARCHAR2	1	1			N

Total: 24 column(s)

Indexes

	Name	Type	Unique
	CDF_I_DF_KEY	NORMAL	NONUNIQUE
	CDF_I_FNAME_STATUS	NORMAL	NONUNIQUE
	CDF_P	NORMAL	UNIQUE
	CDF_U1	NORMAL	UNIQUE

Total: 4 index(s)

Constraints

	Name	Type	Status	Delete rule	Defferable	Deffered
	CDF_C_BCK_FUZZY	Not NULL	Enabled		Not Deferrable	Immediate
	CDF_C_ONL_FUZZY	Not NULL	Enabled		Not Deferrable	Immediate
	CDF_C_STATUS	Not NULL	Enabled		Not Deferrable	Immediate
	CDF_F1	Referential Integrity	Enabled	Cascade	Not Deferrable	Immediate
	CDF_P	Primary Key	Enabled		Not Deferrable	Immediate
	CDF_U1	Unique Key	Enabled		Not Deferrable	Immediate
	SYS_C002911	Check	Enabled		Not Deferrable	Immediate
	SYS_C002912	Check	Enabled		Not Deferrable	Immediate
	SYS_C002913	Check	Enabled		Not Deferrable	Immediate
	SYS_C002914	Check	Enabled		Not Deferrable	Immediate
	SYS_C002915	Check	Enabled		Not Deferrable	Immediate
	SYS_C002916	Check	Enabled		Not Deferrable	Immediate
	SYS_C002917	Check	Enabled		Not Deferrable	Immediate
	SYS_C002918	Check	Enabled		Not Deferrable	Immediate
	SYS_C002919	Check	Enabled		Not Deferrable	Immediate
	SYS_C002920	Check	Enabled		Not Deferrable	Immediate
	SYS_C002921	Check	Enabled		Not Deferrable	Immediate
	SYS_C002922	Check	Enabled		Not Deferrable	Immediate
	SYS_C002923	Check	Enabled		Not Deferrable	Immediate
	SYS_C002924	Check	Enabled		Not Deferrable	Immediate
	SYS_C002925	Check	Enabled		Not Deferrable	Immediate
	SYS_C002926	Check	Enabled		Not Deferrable	Immediate
	SYS_C002927	Check	Enabled		Not Deferrable	Immediate

Total: 23 constraints

Referenced tables

	Name	Owner	Constraint	DELETE_RULE
	CCB	RMAN	CCB_F1	CASCADE

Total: 1 referenced table(s)

Table References

	Name	Owner	Constraint	DELETE_RULE
	DBINC	RMAN	CDF_F1

Total: 1 table reference(s)

Table used by

Owner	Name	Type	Level
RMAN	RC_DATAFILE_COPY	VIEW	0
RMAN	RC_COPY_CORRUPTION	VIEW	0
RMAN	DBMS_RCVCAT	PACKAGE BODY	0
RMAN	DBMS_RCVMAN	PACKAGE BODY	0

Total: 4 used by reference(s)

DDL

  CREATE TABLE "RMAN"."CDF"
   (    "CDF_KEY" NUMBER NOT NULL ENABLE,
    "DBINC_KEY" NUMBER NOT NULL ENABLE,
    "CDF_RECID" NUMBER NOT NULL ENABLE,
    "CDF_STAMP" NUMBER NOT NULL ENABLE,
    "FILE#" NUMBER NOT NULL ENABLE,
    "CREATE_SCN" NUMBER NOT NULL ENABLE,
    "FNAME" VARCHAR2(1024) NOT NULL ENABLE,
    "FNAME_HASHKEY" VARCHAR2(20) 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,
    "COMPLETION_TIME" DATE NOT NULL ENABLE,
    "STATUS" VARCHAR2(1) NOT NULL ENABLE,
    "KEEP_OPTIONS" NUMBER,
    "KEEP_UNTIL" DATE,
    "SCANNED" VARCHAR2(1) NOT NULL ENABLE,
     CONSTRAINT "CDF_C_STATUS" CHECK (status in ('A','U','D','X')) ENABLE,
     CONSTRAINT "CDF_C_ONL_FUZZY" CHECK (onl_fuzzy in ('Y','N')) ENABLE,
     CONSTRAINT "CDF_C_BCK_FUZZY" CHECK (bck_fuzzy in ('Y','N')) ENABLE,
     CONSTRAINT "CDF_P" PRIMARY KEY ("CDF_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 "CDF_U1" UNIQUE ("DBINC_KEY", "CDF_RECID", "CDF_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 "CDF_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