1. SecureFiles and Large Objects Developer's Guide
  2. DBFS Hierarchical Store
  3. Views for DBFS Hierarchical Store

18.5 Views for DBFS Hierarchical Store

The DBFS Hierarchical Stores have several types of views.

See Also:

Oracle Database Reference for the columns and data types of these views

18.5.1 DBA Views

There are several views available for DBFS Hierarchical Store.

Following are the views available for DBFS Hierarchical Store:

  • DBA_DBFS_HS

    This view shows all Database File System (DBFS) hierarchical stores

  • DBA_DBFS_HS_PROPERTIES

    This view shows modifiable properties of all Database File System (DBFS) hierarchical stores.

  • DBA_DBFS_HS_FIXED_PROPERTIES

    This view shows non-modifiable properties of all Database File System (DBFS) hierarchical stores.

  • DBA_DBFS_HS_COMMANDS

    This view shows all the registered store commands for all Database File System (DBFS) hierarchical stores.

18.5.2 User Views

There are several views available for the DBFS Hierarchical Store.

  • USER_DBFS_HS

    This view shows all Database File System (DBFS) hierarchical stores owned by the current user.

  • USER_DBFS_HS_PROPERTIES

    This view shows modifiable properties of all Database File System (DBFS) hierarchical stores owned by current user.

  • USER_DBFS_HS_FIXED_PROPERTIES

    This view shows non-modifiable properties of all Database File System (DBFS) hierarchical stores owned by current user.

  • USER_DBFS_HS_COMMANDS

    This view shows all the registered store commands for all Database File system (DBFS) hierarchical stores owned by current user.

  • USER_DBFS_HS_FILES

    This view shows files in the Database File System (DBFS) hierarchical store owned by the current user and their location on the backend device.