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


TABLE: XDB.XDB$XTABCOLS

Object Details
Object Name: XDB$XTABCOLS
Object Type: TABLE
Owner: XDB
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XDB$IDXTABCOLS_1 NORMAL NONUNIQUE TablespaceSYSAUX ColumnIDXOBJ#
ColumnGROUPNAME
ColumnXMLTABOBJ#
Columns
Name Datatype Length Mandatory Comments
IDXOBJ# NUMBER
Yes
GROUPNAME NVARCHAR2 (60) Yes
XMLTABOBJ# NUMBER
Yes
COLNAME NVARCHAR2 (4000) Yes
COLTYPE NVARCHAR2 (200) Yes
XPATH VARCHAR2 (4000) Yes
FLAGS NUMBER
Yes
Query Text

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


SELECT IDXOBJ#
,      GROUPNAME
,      XMLTABOBJ#
,      COLNAME
,      COLTYPE
,      XPATH
,      FLAGS
FROM XDB.XDB$XTABCOLS;

Dependencies

[top of page]

XDB.XDB$XTABCOLS does not reference any database object

XDB.XDB$XTABCOLS is not referenced by any database object