Oracle 18c: How to load data in Oracle Autonomous Data Warehouse Cloud

This article was written by Skant Gupta and Joel Perez in Oracle OTN.

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

Loading Data into Autonomous Data Warehouse Cloud Database

Data Loading Options

• Data loading via SQL*Net
  • Suitable for small volumes of data
    • SQL*Loader from local filesystem
    • ETL scripts that use DML to insert/update data
• Data loading from Oracle Object Storage
  • Preferred technique for large volumes of data
    • Additionally enables data-sharing with other cloud services
• Stage data in Oracle Object Storage, then load into the database using new PL/SQL APIs

Loading Data from Object Stores

• Source data from files on object stores for data loading
  • Oracle Object Store or AWS S3
  • Any supported Oracle-loader file format
  • Roadmap: any Hadoop file format

If you want to read rest to the article, go across this link : Oracle 18: Autonomous DataWareHouse

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp