DBA Data[Home] [Help] [Dependency Information]

TABLE: OKC.OKC_CA_ART_VERSIONS_GT

Object Details
Object Name: OKC_CA_ART_VERSIONS_GT
Object Type: TABLE
Owner: OKC
Subobject Name:
Status: VALID

Temporary Table Details

OKC.OKC_CA_ART_VERSIONS_GT 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.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Primary Key: OKC_CA_ART_VERSIONS_GT_PK
  1. ColumnARTICLE_SRCH_ID
  2. ColumnARTICLE_VERSION_ID
  3. ColumnARTICLE_ORG_ID
Indexes
Index Type Uniqueness Tablespace Column
OKC_CA_ART_VERSIONS_GT_PK NORMAL UNIQUE Tablespace ColumnARTICLE_SRCH_ID
ColumnARTICLE_VERSION_ID
ColumnARTICLE_ORG_ID
Columns
Name Datatype Length Mandatory Comments
ARTICLE_SRCH_ID NUMBER
Yes
ARTICLE_ID NUMBER

ARTICLE_VERSION_ID NUMBER
Yes
ARTICLE_ORG_ID NUMBER
Yes
ARTICLE_TITLE VARCHAR2 (450)
ARTICLE_TYPE VARCHAR2 (30)
ARTICLE_STANDARD_YN VARCHAR2 (1)
ARTICLE_VERSION_NUMBER NUMBER

ARTICLE_FLAG VARCHAR2 (1)
ARTICLE_ADOPTION_TYPE VARCHAR2 (30)
ARTICLE_ORG_NAME VARCHAR2 (240)
STD_ARTICLE_TITLE VARCHAR2 (450)
STD_ARTICLE_VERSION_NUMBER NUMBER

OBJECT_VERSION_NUMBER NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ARTICLE_SRCH_ID
,      ARTICLE_ID
,      ARTICLE_VERSION_ID
,      ARTICLE_ORG_ID
,      ARTICLE_TITLE
,      ARTICLE_TYPE
,      ARTICLE_STANDARD_YN
,      ARTICLE_VERSION_NUMBER
,      ARTICLE_FLAG
,      ARTICLE_ADOPTION_TYPE
,      ARTICLE_ORG_NAME
,      STD_ARTICLE_TITLE
,      STD_ARTICLE_VERSION_NUMBER
,      OBJECT_VERSION_NUMBER
FROM OKC.OKC_CA_ART_VERSIONS_GT;

Dependencies

[top of page]

OKC.OKC_CA_ART_VERSIONS_GT does not reference any database object

OKC.OKC_CA_ART_VERSIONS_GT is referenced by following:

SchemaAPPS
SynonymOKC_CA_ART_VERSIONS_GT