LOCALOBJECTCACHE System Table Description
The LOCALOBJECTCACHE table is for internal use only.
|
Description
The LOCALOBJECTCACHE table is used to view the contents of the database catalog.
Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.
|
Fields
| Field | Type | Description |
|---|---|---|
OBJECTTYPE |
integer |
Numeric representation of object type |
OBJECTTYPENAME |
string |
String representation of the object type. Possible values: Table, View, Procedure, User, Role, Zone, Sequence, Domain, Temp Table, Function, Schema. |
SCHEMA |
string |
schema of object (if applicable) |
NAME |
string |
Name of the object |
RECORD_ID |
integer |
Record ID of the object |
RECORD_TRANSACTION_ID |
integer |
Record transaction ID of the object |
RECORD_SEQUENCE |
string |
Record sequence of the object |
USE_COUNT |
integer |
Use count of the object |