Creating and Managing Directories on Autonomous Database

Autonomous Database includes a predefined data_pump_dir directory in the database where you can place files. You can also create directories, drop directories, and attach network file systems.

For example you can use the data_pump_dir directory for Data Pump import and export operations. To create additional directories use the database CREATE DIRECTORY command. Use the database DROP DIRECTORY command to drop directories, and use DBMS_CLOUD.LIST_FILES to list the contents of a directory. You can attach a Network File System to a directory location in your Autonomous Database with the DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM procedure.

• Create Directory in Autonomous Database
  To create directories use the database CREATE DIRECTORY command. Using CREATE DIRECTORY you specify the path as a relative path for the new directory.
• Drop Directory in Autonomous Database
  Use the database DROP DIRECTORY command to drop a directory object.
• List Contents of Directory in Autonomous Database
  Use the function DBMS_CLOUD.LIST_FILES to list the contents of a directory.
• Access Network File System from Autonomous Database
  You can attach a Network File System to a directory location in your Autonomous Database.
• Load Data from Directories in Autonomous Database
  As an alternative to an object store location URI, you can specify a directory with DBMS_CLOUD procedures to load or unload data from files in a local directory, including directories created on attached network file systems.