Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
===================================================================
ODBA_LOBS displays the BLOBs and CLOBs contained in all tables in the database. BFILEs are stored outside the database, so they are not described by this view. This view's columns are the same as those in "ALL_LOBS".
·
ALL_LOBS displays the large objects (LOBs) contained in tables accessible to the current user. LOBs include binary large objects (BLOBs) and character large objects (CLOBs). Binary files (BFILEs) are stored outside the database, so they are not displayed by this view or the related views.
·
USER_LOBS describes the LOBs owned by the current user. This view does not display the OWNER column.
Column
|
Datatype
|
NULL
|
Description
|
OWNER | VARCHAR2(30) |
Owner of the object containing the LOB
| |
TABLE_NAME | VARCHAR2(30) |
Name of the object containing the LOB
| |
COLUMN_NAME | VARCHAR2(4000) |
Name of the LOB column or attribute
| |
SEGMENT_NAME | VARCHAR2(30) |
Name of the LOB segment
| |
TABLESPACE_NAME | VARCHAR2(30) |
Name of the tablespace containing the LOB segment
| |
INDEX_NAME | VARCHAR2(30) |
Name of the LOB index
| |
CHUNK | NUMBER |
Size (in bytes) of the LOB chunk as a unit of allocation or manipulation
| |
PCTVERSION | NUMBER |
Maximum percentage of the LOB space used for versioning
| |
RETENTION | NUMBER |
Maximum time duration for versioning of the LOB space
| |
FREEPOOLS | NUMBER |
Number of freepools for this LOB segment
| |
CACHE | VARCHAR2(10) |
Indicates whether and how the LOB data is to be cached in the buffer cache:
·
YES - LOB data is placed in the buffer cache
·
NO - LOB data either is not brought into the buffer cache or is brought into the buffer cache and placed at the least recently used end of the LRU list
·
CACHEREADS - LOB data is brought into the buffer cache only during read operations but not during write operations | |
LOGGING | VARCHAR2(7) |
Indicates whether or not changes to the LOB are logged:
·
NONE - Not specified
See Also: the
*_LOB_SUBPARTITIONS view
·
YES
·
NO | |
ENCRYPT | VARCHAR2(4) |
Indicates whether or not the LOB is encrypted:
·
YES
·
NO
·
NONE - Not applicable to BasicFile LOBs | |
COMPRESSION | VARCHAR2(6) |
Level of compression used for this LOB:
·
MEDIUM
·
HIGH
·
NO
·
NONE - Not applicable to BasicFile LOBs | |
DEDUPLICATION | VARCHAR2(15) |
Kind of deduplication used for this LOB:
·
LOB - Deduplicate
·
NO - Keep duplicates
·
NONE - Not applicable to BasicFile LOBs | |
IN_ROW | VARCHAR2(3) |
Indicates whether some of the LOBs are stored inline with the base row (
YES) or not (NO). For partitioned objects, refer to the *_LOB_PARTITIONS and *_PART_LOBS views. | |
FORMAT | VARCHAR2(15) |
Indicates whether the LOB storage format is dependent on the endianness of the platform:
·
NOT APPLICABLE
·
ENDIAN SPECIFIC
·
ENDIAN NEUTRAL | |
PARTITIONED | VARCHAR2(3) |
Indicates whether the LOB column is in a partitioned table (
YES) or not (NO) | |
SECUREFILE | VARCHAR2(3) |
Indicates whether the LOB is a SecureFile LOB (
YES) or not (NO) |
Note:
1.
select table_name, column_name, segment_name, tablespace_name, index_name, in_row
from DBA_LOBS
where owner ='MDSYS';
TABLE_NAME
|
COLUMN_NAME
|
SEGMENT_NAME
|
TABLE
SPACE_
NAME
|
INDEX_NAME
|
IN_
ROW
|
CS_SRS_ORIG
|
"CS_BOUNDS"."SDO_ELEM_INFO"
|
SYS_LOB0001026430C00012$$
|
SYSTEM
|
SYS_IL0001026430C00012$$
|
YES
|
CS_SRS_ORIG
|
"CS_BOUNDS"."SDO_ORDINATES"
|
SYS_LOB0001026430C00013$$
|
SYSTEM
|
SYS_IL0001026430C00013$$
|
YES
|
SDO_COORD_OP_PARAM_VALS
|
PARAM_VALUE_FILE
|
SYS_LOB0001026659C00006$$
|
SYSTEM
|
SYS_IL0001026659C00006$$
|
YES
|
SDO_COORD_OP_PARAM_VALS
|
SYS_NC00008$
|
SYS_LOB0001026659C00008$$
|
SYSTEM
|
SYS_IL0001026659C00008$$
|
YES
|
SDO_COORD_REF_SYS
|
"LEGACY_CS_BOUNDS"."SDO_ELEM_INFO"
|
SYS_LOB0001026641C00022$$
|
SYSTEM
|
SYS_IL0001026641C00022$$
|
YES
|
SDO_COORD_REF_SYS
|
"LEGACY_CS_BOUNDS"."SDO_ORDINATES"
|
SYS_LOB0001026641C00023$$
|
SYSTEM
|
SYS_IL0001026641C00023$$
|
YES
|
SDO_CS_SRS
|
"CS_BOUNDS"."SDO_ELEM_INFO"
|
SYS_LOB0001026664C00012$$
|
SYSTEM
|
SYS_IL0001026664C00012$$
|
YES
|
SDO_CS_SRS
|
"CS_BOUNDS"."SDO_ORDINATES"
|
SYS_LOB0001026664C00013$$
|
SYSTEM
|
SYS_IL0001026664C00013$$
|
YES
|
SDO_GEOR_SYSDATA_TABLE
|
OTHER_TABLE_NAMES
|
SYS_LOB0001027507C00007$$
|
SYSTEM
|
SYS_IL0001027507C00007$$
|
YES
|
SDO_GEOR_XMLSCHEMA_TABLE
|
XMLSCHEMA
|
SYS_LOB0001027497C00003$$
|
SYSTEM
|
SYS_IL0001027497C00003$$
|
YES
|
SDO_GR_MOSAIC_0
|
SYS_NC00028$
|
SYS_LOB0001059852C00028$$
|
TEMP
|
SYS_IL0001059852C00028$$
|
YES
|
SDO_GR_RDT_1
|
"BLOCKMBR"."SDO_ELEM_INFO"
|
SYS_LOB0001059858C00013$$
|
TEMP
|
SYS_IL0001059858C00013$$
|
YES
|
SDO_GR_RDT_1
|
"BLOCKMBR"."SDO_ORDINATES"
|
SYS_LOB0001059858C00014$$
|
TEMP
|
SYS_IL0001059858C00014$$
|
YES
|
SDO_GR_RDT_1
|
RASTERBLOCK
|
SYS_LOB0001059858C00015$$
|
TEMP
|
SYS_IL0001059858C00015$$
|
YES
|
SDO_GR_RDT_2
|
"BLOCKMBR"."SDO_ELEM_INFO"
|
SYS_LOB0001059866C00014$$
|
TEMP
|
SYS_IL0001059866C00014$$
|
YES
|
SDO_GR_RDT_2
|
"BLOCKMBR"."SDO_ORDINATES"
|
SYS_LOB0001059866C00015$$
|
TEMP
|
SYS_IL0001059866C00015$$
|
YES
|
SDO_GR_RDT_2
|
RASTERBLOCK
|
SYS_LOB0001059866C00016$$
|
TEMP
|
SYS_IL0001059866C00016$$
|
YES
|
SDO_INDEX_METADATA_TABLE
|
"SDO_ROOT_MBR"."SDO_ELEM_INFO"
|
SYS_LOB0000026741C00043$$
|
SYSTEM
|
SYS_IL0000026741C00043$$
|
YES
|
SDO_INDEX_METADATA_TABLE
|
"SDO_ROOT_MBR"."SDO_ORDINATES"
|
SYS_LOB0000026741C00044$$
|
SYSTEM
|
SYS_IL0000026741C00044$$
|
YES
|
SDO_MAPS_TABLE
|
DEFINITION
|
SYS_LOB0000026938C00004$$
|
SYSTEM
|
SYS_IL0000026938C00004$$
|
YES
|
SDO_NETWORK_CONSTRAINTS
|
CLASS
|
SYS_LOB0001027581C00005$$
|
SYSTEM
|
SYS_IL0001027581C00005$$
|
YES
|
SDO_STYLES_TABLE
|
DEFINITION
|
SYS_LOB0000026945C00005$$
|
SYSTEM
|
SYS_IL0000026945C00005$$
|
YES
|
SDO_STYLES_TABLE
|
IMAGE
|
SYS_LOB0000026945C00006$$
|
SYSTEM
|
SYS_IL0000026945C00006$$
|
YES
|
SDO_STYLES_TABLE
|
"GEOMETRY"."SDO_ELEM_INFO"
|
SYS_LOB0000026945C00013$$
|
SYSTEM
|
SYS_IL0000026945C00013$$
|
YES
|
SDO_STYLES_TABLE
|
"GEOMETRY"."SDO_ORDINATES"
|
SYS_LOB0000026945C00014$$
|
SYSTEM
|
SYS_IL0000026945C00014$$
|
YES
|
SDO_THEMES_TABLE
|
STYLING_RULES
|
SYS_LOB0000026958C00006$$
|
SYSTEM
|
SYS_IL0000026958C00006$$
|
YES
|
SDO_TOPO_METADATA_TABLE
|
TOPO_GEOMETRY_LAYERS
|
SYS_LOB0001026543C00004$$
|
SYSTEM
|
SYS_IL0001026543C00004$$
|
YES
|
SDO_XML_SCHEMAS
|
XMLSCHEMA
|
SYS_LOB0001026936C00003$$
|
SYSTEM
|
SYS_IL0001026936C00003$$
|
YES
|
USER_CS_SRS
|
"CS_BOUNDS"."SDO_ELEM_INFO"
|
SYS_LOB0000026782C00012$$
|
SYSTEM
|
SYS_IL0000026782C00012$$
|
YES
|
USER_CS_SRS
|
"CS_BOUNDS"."SDO_ORDINATES"
|
SYS_LOB0000026782C00013$$
|
SYSTEM
|
SYS_IL0000026782C00013$$
|
YES
|
