Table: BS

Properties

Name: | BS
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
| BS_KEY | NUMBER |  |  |  |  | N |  |
| DB_KEY | NUMBER |  |  |  |  | N |  |
| BS_RECID | NUMBER |  |  |  |  | Y |  |
| BS_STAMP | NUMBER |  |  |  |  | Y |  |
| SET_STAMP | NUMBER |  |  |  |  | N |  |
| SET_COUNT | NUMBER |  |  |  |  | N |  |
| BCK_TYPE | VARCHAR2 | 1 | 1 |  |  | Y |  |
| INCR_LEVEL | NUMBER |  |  |  |  | Y |  |
| PIECES | NUMBER |  |  |  |  | N |  |
| START_TIME | DATE | 7 |  |  |  | Y |  |
| COMPLETION_TIME | DATE | 7 |  |  |  | Y |  |
| STATUS | VARCHAR2 | 1 | 1 |  |  | Y |  |
| CONTROLFILE_INCLUDED | VARCHAR2 | 7 | 7 |  |  | Y |  |
| INPUT_FILE_SCAN_ONLY | VARCHAR2 | 3 | 3 |  |  | Y |  |
| KEEP_OPTIONS | NUMBER |  |  |  |  | Y |  |
| KEEP_UNTIL | DATE | 7 |  |  |  | Y |  |

Total: 16 column(s)

Indexes

| Name | Type | Unique
| BS_P | NORMAL | UNIQUE
| BS_U2 | NORMAL | UNIQUE

Total: 2 index(s)

Constraints

| Name | Type | Status | Delete rule | Defferable | Deffered
| BS_C_BCK_TYPE | Not NULL | Enabled |  | Not Deferrable | Immediate
| BS_C_CONTROLFILE_INCLUDED | Not NULL | Enabled |  | Not Deferrable | Immediate
| BS_C_INCR_LEVEL | Not NULL | Enabled |  | Not Deferrable | Immediate
| BS_F1 | Referential Integrity | Enabled | Cascade | Not Deferrable | Immediate
| BS_P | Primary Key | Enabled |  | Not Deferrable | Immediate
| BS_U2 | Unique Key | Enabled |  | Not Deferrable | Immediate
| SYS_C002802 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002803 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002804 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002805 | Check | Enabled |  | Not Deferrable | Immediate
| SYS_C002806 | Check | Enabled |  | Not Deferrable | Immediate

Total: 11 constraints

Referenced tables

| Name | Owner | Constraint | DELETE_RULE
| BCF | RMAN | BCF_F1 | CASCADE
| BDF | RMAN | BDF_F1 | CASCADE
| BP | RMAN | BP_F1 | CASCADE
| BRL | RMAN | BRL_F1 | CASCADE
| BSF | RMAN | BSF_F1 | CASCADE

Total: 5 referenced table(s)

Table References

| Name | Owner | Constraint | DELETE_RULE
| DB | RMAN | BS_F1 |

Total: 1 table reference(s)

Table used by

Owner | Name | Type | Level
RMAN | RC_BACKUP_SET | VIEW | 0
RMAN | RC_BACKUP_PIECE | VIEW | 0
RMAN | RC_BACKUP_DATAFILE | VIEW | 0
RMAN | RC_BACKUP_CONTROLFILE | VIEW | 0
RMAN | RC_BACKUP_SPFILE | VIEW | 0
RMAN | RC_BACKUP_REDOLOG | VIEW | 0
RMAN | RC_BACKUP_CORRUPTION | VIEW | 0
RMAN | DBMS_RCVCAT | PACKAGE BODY | 0
RMAN | DBMS_RCVMAN | PACKAGE BODY | 0

Total: 9 used by reference(s)

DDL

CREATE TABLE "RMAN"."BS"
( "BS_KEY" NUMBER NOT NULL ENABLE,
"DB_KEY" NUMBER NOT NULL ENABLE,
"BS_RECID" NUMBER,
"BS_STAMP" NUMBER,
"SET_STAMP" NUMBER NOT NULL ENABLE,
"SET_COUNT" NUMBER NOT NULL ENABLE,
"BCK_TYPE" VARCHAR2(1),
"INCR_LEVEL" NUMBER,
"PIECES" NUMBER NOT NULL ENABLE,
"START_TIME" DATE,
"COMPLETION_TIME" DATE,
"STATUS" VARCHAR2(1),
"CONTROLFILE_INCLUDED" VARCHAR2(7),
"INPUT_FILE_SCAN_ONLY" VARCHAR2(3),
"KEEP_OPTIONS" NUMBER,
"KEEP_UNTIL" DATE,
CONSTRAINT "BS_C_BCK_TYPE" CHECK (bck_type in ('D','I','L')) ENABLE,
CONSTRAINT "BS_C_INCR_LEVEL" CHECK (incr_level in (0,1,2,3,4)) ENABLE,
CONSTRAINT "BS_C_CONTROLFILE_INCLUDED" CHECK (controlfile_included in
('NONE','BACKUP','STANDBY')) ENABLE,
CONSTRAINT "BS_P" PRIMARY KEY ("BS_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 "BS_U2" UNIQUE ("DB_KEY", "SET_STAMP", "SET_COUNT")
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 "BS_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