Creating and Managing Directories on Autonomous AI Database

Autonomous AI 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 AI Database with the DBMS_CLOUD_ADMIN.ATTACH_FILE_SYSTEM procedure.

• Create Directory in Autonomous AI 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 AI Database

  Use the database DROP DIRECTORY command to drop a directory object.

• List Contents of Directory in Autonomous AI Database

  Use the function DBMS_CLOUD.LIST_FILES to list the contents of a directory.

• Access Network File System from Autonomous AI Database

  You can attach a Network File System to a directory location in your Autonomous AI Database.

• Load Data from Directories in Autonomous AI 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.