Key Procedures in DBMS_CLOUD

Key Procedures in DBMS_CLOUD

1. DBMS_CLOUD.CREATE_CREDENTIAL

   • Registers cloud credentials for secure access.

2. DBMS_CLOUD.DROP_CREDENTIAL

   • Deletes a previously created credential.

3. DBMS_CLOUD.LIST_FILES

   • Lists files in cloud storage locations.

4. DBMS_CLOUD.GET_OBJECT

   • Downloads files from cloud storage to a database directory.

5. DBMS_CLOUD.PUT_OBJECT

   • Uploads files from the database to cloud storage.

6. DBMS_CLOUD.COPY_DATA

   • Imports data from cloud storage into a database table.

7. DBMS_CLOUD.COPY_FILES

   • Copies files from one cloud location to another.

8. DBMS_CLOUD.DELETE_FILE

   • Deletes files from a cloud storage location.

9. DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE

   • Validates the structure and data of an external table.

10. DBMS_CLOUD.CREATE_EXTERNAL_TABLE

    • Creates an external table that reads data directly from cloud storage.