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 databaseCREATE DIRECTORY
command. UsingCREATE DIRECTORY
you specify the path as a relative path for the new directory. - Drop Directory in Autonomous Database
Use the databaseDROP DIRECTORY
command to drop a directory object. - List Contents of Directory in Autonomous Database
Use the functionDBMS_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 withDBMS_CLOUD
procedures to load or unload data from files in a local directory, including directories created on attached network file systems.
Parent topic: Move Files