[Home] [Help] [Dependency Information]
Object Name: | BISM_TEMP |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
APPLSYS.BISM_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000359171C00018$$ | LOB | UNIQUE | SYSTEM | |
SYS_IL0000359171C00023$$ | LOB | UNIQUE | SYSTEM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQID | NUMBER | (20) | ||
USER_VISIBLE | VARCHAR2 | (1) | ||
OBJECT_TYPE_ID | NUMBER | (5) | ||
VERSION | NUMBER | (6) | ||
TIME_DATE_CREATED | DATE | |||
TIME_DATE_MODIFIED | DATE | |||
OBJECT_ID | RAW | (16) | ||
CONTAINER_ID | RAW | (16) | ||
FOLDER_ID | RAW | (16) | ||
CREATED_BY | VARCHAR2 | (64) | ||
LAST_MODIFIED_BY | VARCHAR2 | (64) | ||
OBJECT_NAME | VARCHAR2 | (1333) | ||
TITLE | VARCHAR2 | (128) | ||
APPLICATION | VARCHAR2 | (256) | ||
DATABASE | VARCHAR2 | (256) | ||
DESCRIPTION | VARCHAR2 | (1333) | ||
KEYWORDS | VARCHAR2 | (1333) | ||
XML | CLOB | (4000) | ||
APPLICATION_SUBTYPE1 | VARCHAR2 | (32) | ||
COMP_SUBTYPE1 | VARCHAR2 | (256) | ||
COMP_SUBTYPE2 | VARCHAR2 | (512) | ||
COMP_SUBTYPE3 | VARCHAR2 | (1333) | ||
EXTENSIBLE_ATTRIBUTES | CLOB | (4000) | ||
TIME_DATE_LAST_ACCESSED | DATE | |||
IS_SHORTCUTON | VARCHAR2 | (1) | ||
PRIVILEGE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SEQID
, USER_VISIBLE
, OBJECT_TYPE_ID
, VERSION
, TIME_DATE_CREATED
, TIME_DATE_MODIFIED
, OBJECT_ID
, CONTAINER_ID
, FOLDER_ID
, CREATED_BY
, LAST_MODIFIED_BY
, OBJECT_NAME
, TITLE
, APPLICATION
, DATABASE
, DESCRIPTION
, KEYWORDS
, XML
, APPLICATION_SUBTYPE1
, COMP_SUBTYPE1
, COMP_SUBTYPE2
, COMP_SUBTYPE3
, EXTENSIBLE_ATTRIBUTES
, TIME_DATE_LAST_ACCESSED
, IS_SHORTCUTON
, PRIVILEGE
FROM APPLSYS.BISM_TEMP;
APPLSYS.BISM_TEMP does not reference any database object
APPLSYS.BISM_TEMP is referenced by following:
|
|
|