STORAGE_POLICIES

Monitors the current storage policies in effect for one or more database objects.

Monitors the current storage policies in effect for one or more database objects.

Column Name Data Type Description
NAMESPACE_NAME VARCHAR For Eon Mode databases, namespace for which information is listed.
SCHEMA_NAME VARCHAR

Schema name for which information is listed.

If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, n1.s refers to schema s in namespace n1.

OBJECT_NAME VARCHAR The name of the database object associated through the storage policy.
POLICY_DETAILS VARCHAR The object type of the storage policy.
LOCATION_LABEL VARCHAR (128) The label for this storage location.

Privileges

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.

See also