Table: DBINC

Properties

Name: | DBINC
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 |  |
| DB_KEY | NUMBER |  |  |  |  | N |  |
| DB_NAME | VARCHAR2 | 8 | 8 |  |  | N |  |
| RESET_SCN | NUMBER |  |  |  |  | N |  |
| RESET_TIME | DATE | 7 |  |  |  | N |  |
| PARENT_DBINC_KEY | NUMBER |  |  |  |  | Y |  |
| CF_CREATE_TIME | DATE | 7 |  |  |  | Y |  |
| CKP_SCN | NUMBER |  |  |  |  | N | 0 |
| FULL_CKP_CF_SEQ | NUMBER |  |  |  |  | N | 0 |
| JOB_CKP_CF_SEQ | NUMBER |  |  |  |  | N | 0 |
| HIGH_TS_RECID | NUMBER |  |  |  |  | Y |  |
| HIGH_DF_RECID | NUMBER |  |  |  |  | Y |  |
| HIGH_RT_RECID | NUMBER |  |  |  |  | Y |  |
| HIGH_ORL_RECID | NUMBER |  |  |  |  | Y |  |
| HIGH_OFFR_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_RLH_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_AL_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_BS_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_BP_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_BDF_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_CDF_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_BRL_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_BCB_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_CCB_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_DO_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_PC_RECID | NUMBER |  |  |  |  | N | 0 |
| HIGH_BSF_RECID | NUMBER |  |  |  |  | N | 0 |

Total: 27 column(s)

Indexes

| Name | Type | Unique
| DBINC_P | NORMAL | UNIQUE
| DBINC_U1 | NORMAL | UNIQUE

Total: 2 index(s)

Constraints

| Name | Type | Status | Delete rule | Defferable | Deffered
| DBINC_F1 | Referential Integrity | Enabled | Cascade | Not Deferrable | Immediate
| DBINC_P | Primary Key | Enabled |  | Not Deferrable | Immediate
| DBINC_U1 | Unique Key | Enabled |  | Not Deferrable | Immediate
| SYS_C002667 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002668 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002669 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002670 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002671 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002672 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002673 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002674 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002675 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002676 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002677 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002678 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002679 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002680 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002681 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002682 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002683 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002684 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002685 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002686 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002687 | Check | Enabled |  | Not Deferrable | Immediate

Total: 24 constraints

Referenced tables

| Name | Owner | Constraint | DELETE_RULE
| AL | RMAN | AL_F1 | CASCADE
| CCF | RMAN | CCF_F1 | CASCADE
| CDF | RMAN | CDF_F1 | CASCADE
| CKP | RMAN | CKP_F1 | CASCADE
| DB | RMAN | DB_F1 | NO ACTION
| OFFR | RMAN | OFFR_F1 | CASCADE
| RLH | RMAN | RLH_F1 | CASCADE
| RR | RMAN | RR_F1 | CASCADE
| RT | RMAN | RT_F1 | CASCADE
| TS | RMAN | TS_F1 | CASCADE
| XCF | RMAN | XCF_F1 | CASCADE
| XDF | RMAN | XDF_F1 | CASCADE

Total: 12 referenced table(s)

Table References

| Name | Owner | Constraint | DELETE_RULE
| DB | RMAN | DBINC_F1 |

Total: 1 table reference(s)

Table used by

Owner | Name | Type | Level
RMAN | RC_DATABASE | VIEW | 0
RMAN | RC_DATABASE_INCARNATION | VIEW | 0
RMAN | RC_RESYNC | VIEW | 0
RMAN | RC_CHECKPOINT | VIEW | 0
RMAN | RC_TABLESPACE | VIEW | 0
RMAN | RC_DATAFILE | VIEW | 0
RMAN | RC_REDO_THREAD | VIEW | 0
RMAN | RC_REDO_LOG | VIEW | 0
RMAN | RC_LOG_HISTORY | VIEW | 0
RMAN | RC_ARCHIVED_LOG | VIEW | 0
RMAN | RC_BACKUP_DATAFILE | VIEW | 0
RMAN | RC_BACKUP_CONTROLFILE | VIEW | 0
RMAN | RC_DATAFILE_COPY | VIEW | 0
RMAN | RC_CONTROLFILE_COPY | VIEW | 0
RMAN | RC_BACKUP_REDOLOG | VIEW | 0
RMAN | RC_BACKUP_CORRUPTION | VIEW | 0
RMAN | RC_COPY_CORRUPTION | VIEW | 0
RMAN | RC_OFFLINE_RANGE | VIEW | 0
RMAN | RC_STORED_SCRIPT | VIEW | 0
RMAN | RC_PROXY_DATAFILE | VIEW | 0
RMAN | RC_PROXY_CONTROLFILE | VIEW | 0
RMAN | DBMS_RCVCAT | PACKAGE BODY | 0
RMAN | DBMS_RCVMAN | PACKAGE BODY | 0

Total: 23 used by reference(s)

DDL

CREATE TABLE "RMAN"."DBINC"
( "DBINC_KEY" NUMBER NOT NULL ENABLE,
"DB_KEY" NUMBER NOT NULL ENABLE,
"DB_NAME" VARCHAR2(8) NOT NULL ENABLE,
"RESET_SCN" NUMBER NOT NULL ENABLE,
"RESET_TIME" DATE NOT NULL ENABLE,
"PARENT_DBINC_KEY" NUMBER,
"CF_CREATE_TIME" DATE,
"CKP_SCN" NUMBER DEFAULT 0 NOT NULL ENABLE,
"FULL_CKP_CF_SEQ" NUMBER DEFAULT 0 NOT NULL ENABLE,
"JOB_CKP_CF_SEQ" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_TS_RECID" NUMBER,
"HIGH_DF_RECID" NUMBER,
"HIGH_RT_RECID" NUMBER,
"HIGH_ORL_RECID" NUMBER,
"HIGH_OFFR_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_RLH_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_AL_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BS_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BP_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BDF_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_CDF_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BRL_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BCB_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_CCB_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_DO_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_PC_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
"HIGH_BSF_RECID" NUMBER DEFAULT 0 NOT NULL ENABLE,
CONSTRAINT "DBINC_P" PRIMARY KEY ("DBINC_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 "DBINC_U1" UNIQUE ("DB_KEY", "RESET_SCN", "RESET_TIME")
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 "DBINC_F1" FOREIGN KEY ("DB_KEY")
REFERENCES "RMAN"."DB" ("DB_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