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

VIEW: SYS.KU$_SCHEMAOBJNUM_VIEW

Object Details
Object Name: KU$_SCHEMAOBJNUM_VIEW
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJ_NUM NUMBER

DATAOBJ_NUM NUMBER

OWNER_NUM NUMBER

OWNER_NAME VARCHAR2 (128)
NAME VARCHAR2 (128)
NAMESPACE NUMBER

SUBNAME VARCHAR2 (128)
TYPE_NUM NUMBER

TYPE_NAME VARCHAR2 (45)
CTIME VARCHAR2 (19)
MTIME VARCHAR2 (19)
STIME VARCHAR2 (19)
STATUS NUMBER

REMOTEOWNER VARCHAR2 (128)
LINKNAME VARCHAR2 (128)
FLAGS NUMBER

OID RAW (16)
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

SPARE4 VARCHAR2 (1000)
SPARE5 VARCHAR2 (1000)
SPARE6 VARCHAR2 (19)
OWNER_NAME2 VARCHAR2 (128)
SIGNATURE RAW (16)
SPARE7 NUMBER

SPARE8 NUMBER

SPARE9 NUMBER

Query Text

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


SELECT OBJ_NUM
,      DATAOBJ_NUM
,      OWNER_NUM
,      OWNER_NAME
,      NAME
,      NAMESPACE
,      SUBNAME
,      TYPE_NUM
,      TYPE_NAME
,      CTIME
,      MTIME
,      STIME
,      STATUS
,      REMOTEOWNER
,      LINKNAME
,      FLAGS
,      OID
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      OWNER_NAME2
,      SIGNATURE
,      SPARE7
,      SPARE8
,      SPARE9
FROM SYS.KU$_SCHEMAOBJNUM_VIEW;

Dependencies

[top of page]

SYS.KU$_SCHEMAOBJNUM_VIEW references the following:

SchemaSYS
PL/SQL PackageDBMS_METADATA - show dependent code
TYPEKU$_OBJNUMSET
TYPEKU$_SCHEMAOBJ_T
ViewKU$_SCHEMAOBJ_VIEW
PL/SQL PackageSTANDARD - show dependent code
SYS.KU$_SCHEMAOBJNUM_VIEW is referenced by following:

SchemaSYS
ViewKU$_EQNTABLE_DATA_VIEW
ViewKU$_HTABLE_DATA_VIEW
ViewKU$_HTPART_DATA_VIEW
ViewKU$_HTSPART_DATA_VIEW
ViewKU$_IOTABLE_DATA_VIEW
ViewKU$_IOTPART_DATA_VIEW
ViewKU$_NIOTABLE_DATA_VIEW
ViewKU$_NTABLE_DATA_VIEW