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


TABLE: XDB.JSON$COLLECTION_METADATA

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

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: JSON$COLLECTION_METADATA_PK
  1. ColumnOWNER
  2. ColumnURI_NAME
Indexes
Index Type Uniqueness Tablespace Column
JSON$COLLECTION_METADATA_PK NORMAL UNIQUE TablespaceSYSAUX ColumnOWNER
ColumnURI_NAME
Columns
Name Datatype Length Mandatory Comments
URI_NAME NVARCHAR2 (510) Yes
OWNER VARCHAR2 (128) Yes
OBJECT_TYPE VARCHAR2 (10) Yes
OBJECT_SCHEMA VARCHAR2 (128) Yes
OBJECT_NAME VARCHAR2 (128) Yes
CREATED_ON TIMESTAMP(6) (11) Yes
CREATE_MODE VARCHAR2 (10) Yes
JSON_DESCRIPTOR VARCHAR2 (4000) Yes
Query Text

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


SELECT URI_NAME
,      OWNER
,      OBJECT_TYPE
,      OBJECT_SCHEMA
,      OBJECT_NAME
,      CREATED_ON
,      CREATE_MODE
,      JSON_DESCRIPTOR
FROM XDB.JSON$COLLECTION_METADATA;

Dependencies

[top of page]

XDB.JSON$COLLECTION_METADATA does not reference any database object

XDB.JSON$COLLECTION_METADATA is referenced by following:

SchemaXDB
Package BodyDBMS_SODA_DML - show dependent code
ViewJSON$COLLECTION_METADATA_V
ViewJSON$USER_COLLECTION_METADATA