Decrypt Data While Importing from Object Storage
You can decrypt and load data from encrypted files stored in Object Storage. You can also decrypt encrypted data on Object Storage that you use in an external table.
Note:
This option is only supported for Object Storage files less than 4 GB.This option is applicable for the following procedures:
-
DBMS_CLOUD.COPY_DATA
-
DBMS_CLOUD.CREATE_EXTERNAL_TABLE
-
DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE
-
DBMS_CLOUD.CREATE_HYBRID_PART_TABLE
For
DBMS_CLOUD.CREATE_HYBRID_PART_TABLE
this option is only applicable to the Object Storage files. DBMS_CLOUD.COPY_COLLECTION
Topics
- Decrypt and Load Data Using DBMS_CRYPTO Algorithms
Shows the steps to decrypt encrypted files from Object Storage and load the data into a table on Autonomous Database (the decrypt step usesDBMS_CRYPTO
algorithms). - Decrypt and Load Data with a User Defined Function
Shows the steps to decrypt files in Object Storage and load the data into tables using a user-defined decryption function.
Decrypt and Load Data Using DBMS_CRYPTO Algorithms
Shows the
steps to decrypt encrypted files from Object Storage and load the data into a table on Autonomous Database (the decrypt step uses
DBMS_CRYPTO
algorithms).
As a prerequisite you must have encrypted files and uploaded the files into
Object Storage. This example uses a CSV file and it is assumed that the file is encrypted
using DBMS_CRYPTO.ENCRYPT_AES256 + DBMS_CRYPTO.CHAIN_CBC +
DBMS_CRYPTO.PAD_PKCS5
algorithm and uploaded to your Cloud Object Storage.
See ENCRYPT Function for more information on
the ENCRYPT
function.
See DBMS_CRYPTO Operational Notes for more information on generating an encryption key.
To decrypt and load data into an existing table on Autonomous Database from Object Storage:
Parent topic: Decrypt Data While Importing from Object Storage
Decrypt and Load Data with a User Defined Function
Shows the steps to decrypt files in Object Storage and load the data into tables using a user-defined decryption function.
As a prerequisite for these steps you must have encrypted files and uploaded
the files into Object Storage. This example uses a CSV file and it is assumed that the file
is encrypted using DBMS_CRYPTO.ENCRYPT_AES256 + DBMS_CRYPTO.CHAIN_CBC +
DBMS_CRYPTO.PAD_PKCS5
algorithm and uploaded to your Cloud Object Storage.
See ENCRYPT Function for more information on
the ENCRYPT
function.
See DBMS_CRYPTO Operational Notes for more information on generating an encryption key.
To decrypt and load data into an existing table on Autonomous Database from Object Storage:
Parent topic: Decrypt Data While Importing from Object Storage