In this post, you will learn how to export the HR Schema from On-Prem Oracle Database to ADWC instance using Data Pump Export (expdp).

Log in to On-Prem Machine with oracle user and create a directory to place the dump files generated by using data pump.

On the On-Prem Machine, invoke SQL*Plus and log in to the database as the sys user and create a directory.

Now invoke the Data Pump export as the SYSTEM user for HR schema.

In the next post, we can move the dump file to object storage bucket which we created earlier post.

Thank you for giving your valuable time to read the above information.

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

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.