Load Data or Query Data from Files in a Directory
You can use
DBMS_CLOUD
procedures to load data from
files in a directory, including directories created on attached network file systems. You can
also use these procedures to create external tables that you can use to query data.
The following DBMS_CLOUD
procedures support loading data into the database from a directory:
DBMS_CLOUD.COPY_COLLECTION
DBMS_CLOUD.COPY_DATA
In addition, the following DBMS_CLOUD
procedures support creating external tables from data
in files in a directory.
DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE
DBMS_CLOUD.CREATE_EXTERNAL_TABLE
DBMS_CLOUD.CREATE_HYBRID_PART_TABLE
Depending on the procedure, use either the file_uri_list
parameter or the partitioning_clause
parameter to specify files in one or
more directories.
To load data from a directory, you do not need to include the
credential_name
parameter, but you need READ
object
privileges on the directory.
For example, you can load data into an existing table using DBMS_CLOUD.COPY_DATA
:
See COPY_DATA Procedure for more information.
See Attach Network File System to Autonomous Database for information on attaching network file systems.
Parent topic: Load Data into Autonomous Database