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


TABLE: LBACSYS.OLS$LAB

Object Details
Object Name: OLS$LAB
Object Type: TABLE
Owner: LBACSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: OLS_LABEL_PK
  1. ColumnNLABEL
Indexes
Index Type Uniqueness Tablespace Column
OLS_LABEL_PK NORMAL UNIQUE TablespaceSYSTEM ColumnNLABEL
I_OLS$LAB_1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnTAG#
I_OLS$LAB_2 NORMAL NONUNIQUE TablespaceSYSTEM ColumnILABEL
ColumnPOL#
Foreign Keys
Table
Foreign Table Foreign Key Column
OLS$LAB OLS_LABEL_POLICY_FK TableOLS$POL OLS$LAB POL#
Columns
Name Datatype Length Mandatory Comments
TAG# NUMBER (10)
POL# NUMBER
Yes
NLABEL NUMBER (10) Yes
SLABEL VARCHAR2 (4000) Yes
ILABEL VARCHAR2 (4000) Yes
FLAGS NUMBER
Yes
Query Text

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


SELECT TAG#
,      POL#
,      NLABEL
,      SLABEL
,      ILABEL
,      FLAGS
FROM LBACSYS.OLS$LAB;

Dependencies

[top of page]

LBACSYS.OLS$LAB does not reference any database object

LBACSYS.OLS$LAB is referenced by following:

SchemaDVSYS
ViewDBA_DV_POLICY_LABEL
Package BodyDBMS_MACOLS - show dependent code
Package BodyDBMS_MACOLS_SESSION - show dependent code
ViewDV$OLS_POLICY_LABEL
ViewDV$POLICY_LABEL
SchemaLBACSYS
ViewALL_SA_DATA_LABELS
ViewALL_SA_LABELS
ViewDBA_LBAC_DATA_LABELS
ViewDBA_LBAC_LABELS
ViewDBA_LBAC_LABEL_TAGS
ViewDBA_SA_LABELS
ProcedureFEATURE_USAGE - show dependent code
Package BodyLBAC$SA - show dependent code
Package BodyLBAC$SA_LABELS - show dependent code
Package BodyLBAC_UTL - show dependent code
Package BodyOLS_DIP_NTFY - show dependent code
Package BodySA_COMPONENTS - show dependent code
Package BodySA_SESSION - show dependent code
Package BodySA_USER_ADMIN - show dependent code
Package BodySA_UTL - show dependent code