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

Leave a Reply