Table: AL

Properties

Name: | AL
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
| AL_KEY | NUMBER |  |  |  |  | N |  |
| DBINC_KEY | NUMBER |  |  |  |  | N |  |
| AL_RECID | NUMBER |  |  |  |  | N |  |
| AL_STAMP | NUMBER |  |  |  |  | N |  |
| THREAD# | NUMBER |  |  |  |  | N |  |
| SEQUENCE# | NUMBER |  |  |  |  | N |  |
| LOW_SCN | NUMBER |  |  |  |  | N |  |
| LOW_TIME | DATE | 7 |  |  |  | N |  |
| NEXT_SCN | NUMBER |  |  |  |  | N |  |
| NEXT_TIME | DATE | 7 |  |  |  | Y |  |
| FNAME | VARCHAR2 | 1024 | 1024 |  |  | Y |  |
| FNAME_HASHKEY | VARCHAR2 | 20 | 20 |  |  | Y |  |
| ARCHIVED | VARCHAR2 | 1 | 1 |  |  | N |  |
| BLOCKS | NUMBER |  |  |  |  | N |  |
| BLOCK_SIZE | NUMBER |  |  |  |  | N |  |
| COMPLETION_TIME | DATE | 7 |  |  |  | N |  |
| IS_STANDBY | VARCHAR2 | 1 | 1 |  |  | Y |  |
| STATUS | VARCHAR2 | 1 | 1 |  |  | N |  |
| DICTIONARY_BEGIN | VARCHAR2 | 3 | 3 |  |  | Y |  |
| DICTIONARY_END | VARCHAR2 | 3 | 3 |  |  | Y |  |

Total: 20 column(s)

Indexes

| Name | Type | Unique
| AL_I_2 | NORMAL | NONUNIQUE
| AL_I_FNAME_STATUS | NORMAL | NONUNIQUE
| AL_P | NORMAL | UNIQUE
| AL_U1 | NORMAL | UNIQUE

Total: 4 index(s)

Constraints

| Name | Type | Status | Delete rule | Defferable | Deffered
| AL_C_ARCHIVED | Not NULL | Enabled |  | Not Deferrable | Immediate
| AL_C_IS_STANDBY | Not NULL | Enabled |  | Not Deferrable | Immediate
| AL_C_STATUS | Not NULL | Enabled |  | Not Deferrable | Immediate
| AL_F1 | Referential Integrity | Enabled | Cascade | Not Deferrable | Immediate
| AL_P | Primary Key | Enabled |  | Not Deferrable | Immediate
| AL_U1 | Unique Key | Enabled |  | Not Deferrable | Immediate
| SYS_C002782 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002783 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002784 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002785 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002786 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002787 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002788 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002789 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002790 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002791 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002792 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002793 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002794 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002795 | Check | Enabled |  | Not Deferrable | Immediate

Total: 20 constraints

Table References

| Name | Owner | Constraint | DELETE_RULE
| DBINC | RMAN | AL_F1 |

Total: 1 table reference(s)

Table used by

Owner | Name | Type | Level
RMAN | RC_ARCHIVED_LOG | VIEW | 0
RMAN | DBMS_RCVCAT | PACKAGE BODY | 0
RMAN | DBMS_RCVMAN | PACKAGE BODY | 0

Total: 3 used by reference(s)

DDL

CREATE TABLE "RMAN"."AL"
( "AL_KEY" NUMBER NOT NULL ENABLE,
"DBINC_KEY" NUMBER NOT NULL ENABLE,
"AL_RECID" NUMBER NOT NULL ENABLE,
"AL_STAMP" NUMBER NOT NULL ENABLE,
"THREAD#" NUMBER NOT NULL ENABLE,
"SEQUENCE#" NUMBER NOT NULL ENABLE,
"LOW_SCN" NUMBER NOT NULL ENABLE,
"LOW_TIME" DATE NOT NULL ENABLE,
"NEXT_SCN" NUMBER NOT NULL ENABLE,
"NEXT_TIME" DATE,
"FNAME" VARCHAR2(1024),
"FNAME_HASHKEY" VARCHAR2(20),
"ARCHIVED" VARCHAR2(1) NOT NULL ENABLE,
"BLOCKS" NUMBER NOT NULL ENABLE,
"BLOCK_SIZE" NUMBER NOT NULL ENABLE,
"COMPLETION_TIME" DATE NOT NULL ENABLE,
"IS_STANDBY" VARCHAR2(1),
"STATUS" VARCHAR2(1) NOT NULL ENABLE,
"DICTIONARY_BEGIN" VARCHAR2(3),
"DICTIONARY_END" VARCHAR2(3),
CONSTRAINT "AL_C_ARCHIVED" CHECK (archived in ('Y','N')) ENABLE,
CONSTRAINT "AL_C_STATUS" CHECK (status in ('A','U','D','X')) ENABLE,
CONSTRAINT "AL_C_IS_STANDBY" CHECK (is_standby in ('Y','N')) ENABLE,
CONSTRAINT "AL_P" PRIMARY KEY ("AL_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 "AL_U1" UNIQUE ("DBINC_KEY", "AL_RECID", "AL_STAMP", "IS_STANDBY")
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 "AL_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