DBA_SODA_COLLECTIONS

5.358 DBA_SODA_COLLECTIONS

DBA_SODA_COLLECTIONS describes all Simple Oracle Document Access (SODA) collections in the database.

Related View

USER_SODA_COLLECTIONS describes the SODA collections owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`URI_NAME`	`NVARCHAR2(255)`	`NOT NULL`	Collection name
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the collection
`OBJECT_TYPE`	`VARCHAR2(10)`	`NOT NULL`	Indicates whether the collection is table-based (`TABLE`) or view-based (`VIEW`)
`OBJECT_SCHEMA`	`VARCHAR2(128)`	`NOT NULL`	Name of the schema that includes the table or view on which the collection is based
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table or view on which the collection is based
`CREATED_ON`	`TIMESTAMP(6)`	`NOT NULL`	Collection creation time
`CREATE_MODE`	`VARCHAR2(10)`	`NOT NULL`	Creation mode. Possible values: `DDL`: A new table was created at collection creation time `MAP`: The collection was created by mapping a preexisting table or view Note: For view-based collections, the value of this column is always `MAP`. New views are not created for view-based collections. A view-based collection is always created by mapping a preexisting view.
`JSON_DESCRIPTOR`	`VARCHAR2(4000)`	`NOT NULL`	Collection metadata, expressed in JavaScript Object Notation (JSON)

Note:

The DBA_SODA_COLLECTIONS view is available only in Oracle Autonomous Database. However, the USER_SODA_COLLECTIONS view is available in on-premises Oracle databases and Oracle Autonomous Database.