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


TABLE: SYS.XS$NSTMPL

Object Details
Object Name: XS$NSTMPL
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: XS$NSTMPL_PK
  1. ColumnNS#
Indexes
Index Type Uniqueness Tablespace Column
XS$NSTMPL_PK NORMAL UNIQUE TablespaceSYSTEM ColumnNS#
Foreign Keys
Table
Foreign Table Foreign Key Column
XS$NSTMPL XS$NSTMP1_FK2 TableXS$ACL XS$NSTMPL ACL#
XS$NSTMPL XS$NSTMPL_FK1 TableXS$OBJ XS$NSTMPL NS#
TableXS$NSTMPL_ATTR XS$NSTMPL_ATTR_FK XS$NSTMPL XS$NSTMPL_ATTR NS#
Columns
Name Datatype Length Mandatory Comments
NS# NUMBER
Yes
ACL# NUMBER

HSCHEMA VARCHAR2 (128)
HPNAME VARCHAR2 (128)
HFNAME VARCHAR2 (128)
CTIME TIMESTAMP(6) (11)
MTIME TIMESTAMP(6) (11)
DESCRIPTION VARCHAR2 (4000)
Query Text

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


SELECT NS#
,      ACL#
,      HSCHEMA
,      HPNAME
,      HFNAME
,      CTIME
,      MTIME
,      DESCRIPTION
FROM SYS.XS$NSTMPL;

Dependencies

[top of page]

SYS.XS$NSTMPL does not reference any database object

SYS.XS$NSTMPL is referenced by following:

SchemaSYS
ViewDBA_XS_NS_TEMPLATES
ViewKU$_XSNSPACE_VIEW
Package BodyXS_ACL_INT - show dependent code
Package BodyXS_DIAG_INT - show dependent code
Package BodyXS_NAMESPACE_INT - show dependent code