[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ALL_PART_LOBS |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TABLE_OWNER | VARCHAR2 | (128) | Yes | |
| TABLE_NAME | VARCHAR2 | (128) | Yes | |
| COLUMN_NAME | VARCHAR2 | (4000) | ||
| LOB_NAME | VARCHAR2 | (128) | Yes | |
| LOB_INDEX_NAME | VARCHAR2 | (128) | Yes | |
| DEF_CHUNK | NUMBER | Yes | ||
| DEF_PCTVERSION | NUMBER | Yes | ||
| DEF_CACHE | VARCHAR2 | (10) | ||
| DEF_IN_ROW | VARCHAR2 | (3) | ||
| DEF_TABLESPACE_NAME | VARCHAR2 | (30) | ||
| DEF_INITIAL_EXTENT | VARCHAR2 | (40) | ||
| DEF_NEXT_EXTENT | VARCHAR2 | (40) | ||
| DEF_MIN_EXTENTS | VARCHAR2 | (40) | ||
| DEF_MAX_EXTENTS | VARCHAR2 | (40) | ||
| DEF_MAX_SIZE | VARCHAR2 | (40) | ||
| DEF_RETENTION | VARCHAR2 | (7) | ||
| DEF_MINRET | VARCHAR2 | (40) | ||
| DEF_PCT_INCREASE | VARCHAR2 | (40) | ||
| DEF_FREELISTS | VARCHAR2 | (40) | ||
| DEF_FREELIST_GROUPS | VARCHAR2 | (40) | ||
| DEF_LOGGING | VARCHAR2 | (7) | ||
| DEF_BUFFER_POOL | VARCHAR2 | (7) | ||
| DEF_FLASH_CACHE | VARCHAR2 | (7) | ||
| DEF_CELL_FLASH_CACHE | VARCHAR2 | (7) | ||
| DEF_ENCRYPT | VARCHAR2 | (4) | ||
| DEF_COMPRESS | VARCHAR2 | (6) | ||
| DEF_DEDUPLICATE | VARCHAR2 | (15) | ||
| DEF_SECUREFILE | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT TABLE_OWNER
, TABLE_NAME
, COLUMN_NAME
, LOB_NAME
, LOB_INDEX_NAME
, DEF_CHUNK
, DEF_PCTVERSION
, DEF_CACHE
, DEF_IN_ROW
, DEF_TABLESPACE_NAME
, DEF_INITIAL_EXTENT
, DEF_NEXT_EXTENT
, DEF_MIN_EXTENTS
, DEF_MAX_EXTENTS
, DEF_MAX_SIZE
, DEF_RETENTION
, DEF_MINRET
, DEF_PCT_INCREASE
, DEF_FREELISTS
, DEF_FREELIST_GROUPS
, DEF_LOGGING
, DEF_BUFFER_POOL
, DEF_FLASH_CACHE
, DEF_CELL_FLASH_CACHE
, DEF_ENCRYPT
, DEF_COMPRESS
, DEF_DEDUPLICATE
, DEF_SECUREFILE
FROM SYS.ALL_PART_LOBS;
SYS
ATTRCOL$
COL$
LOB$
OBJ$
OBJAUTH$
PARTLOB$
TS$
USER$
PUBLIC
ALL_PART_LOBS
|
|
|
|