Properties

Name:	TSATT
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
	DBINC_KEY	NUMBER					N
	TS#	NUMBER					N
	CREATE_SCN	NUMBER					N
	START_CKP_KEY	NUMBER					N
	END_CKP_KEY	NUMBER					Y
	RBS_COUNT	NUMBER					Y

Total: 6 column(s)

Indexes

	Name	Type	Unique
	TSATT_U1	NORMAL	UNIQUE

Total: 1 index(s)

Constraints

	Name	Type	Status	Delete rule	Defferable	Deffered
	SYS_C002712	Check	Enabled		Not Deferrable	Immediate
	SYS_C002713	Check	Enabled		Not Deferrable	Immediate
	SYS_C002714	Check	Enabled		Not Deferrable	Immediate
	SYS_C002715	Check	Enabled		Not Deferrable	Immediate
	TSATT_F1	Referential Integrity	Enabled	Cascade	Not Deferrable	Immediate
	TSATT_F2	Referential Integrity	Enabled	No Action	Not Deferrable	Immediate
	TSATT_F3	Referential Integrity	Enabled	No Action	Not Deferrable	Immediate
	TSATT_U1	Unique Key	Enabled		Not Deferrable	Immediate

Total: 8 constraints

Table References

	Name	Owner	Constraint	DELETE_RULE
	CKP	RMAN	TSATT_F2
	CKP	RMAN	TSATT_F3
	TS	RMAN	TSATT_F1

Total: 3 table reference(s)

Table used by

Owner	Name	Type	Level
RMAN	DBMS_RCVCAT	PACKAGE BODY	0
RMAN	DBMS_RCVMAN	PACKAGE BODY	0

Total: 2 used by reference(s)

DDL

  CREATE TABLE "RMAN"."TSATT"
   (    "DBINC_KEY" NUMBER NOT NULL ENABLE,
    "TS#" NUMBER NOT NULL ENABLE,
    "CREATE_SCN" NUMBER NOT NULL ENABLE,
    "START_CKP_KEY" NUMBER NOT NULL ENABLE,
    "END_CKP_KEY" NUMBER,
    "RBS_COUNT" NUMBER,
     CONSTRAINT "TSATT_U1" UNIQUE ("DBINC_KEY", "TS#", "CREATE_SCN", "END_CKP_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 "TSATT_F1" FOREIGN KEY ("DBINC_KEY", "TS#", "CREATE_SCN")
      REFERENCES "RMAN"."TS" ("DBINC_KEY", "TS#", "CREATE_SCN") ON DELETE CASCADE ENABLE,
     CONSTRAINT "TSATT_F2" FOREIGN KEY ("START_CKP_KEY")
      REFERENCES "RMAN"."CKP" ("CKP_KEY") ENABLE,
     CONSTRAINT "TSATT_F3" FOREIGN KEY ("END_CKP_KEY")
      REFERENCES "RMAN"."CKP" ("CKP_KEY") 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