Table: CONFIG
Table: CONFIG
| Name: | CONFIG |
| 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: |
| Name | Type | Length | Nchar Length | Precision | Scale | NULL | Default | Description | |
|
|
NAME | VARCHAR2 | 30 | 30 | N | ||||
|
|
VALUE | VARCHAR2 | 100 | 100 | Y |
| Name | Type | Status | Delete rule | Defferable | Deffered | |
|
|
SYS_C003002 | Check | Enabled | Not Deferrable | Immediate |
CREATE TABLE "RMAN"."CONFIG"
( "NAME" VARCHAR2(30) NOT NULL ENABLE,
"VALUE" VARCHAR2(100)
) 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