18.5 Views for DBFS Hierarchical Store
The DBFS Hierarchical Stores have several types of views.
- DBA Views
There are several views available for DBFS Hierarchical Store. - User Views
There are several views available for the DBFS Hierarchical Store.
See Also:
Oracle Database Reference for the columns and data types of these views
Parent topic: DBFS Hierarchical Store
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.
Parent topic: Views for DBFS Hierarchical Store
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.
Parent topic: Views for DBFS Hierarchical Store