Creating a Azure Oracle Database and Import Database dump file placed in BLOB storage into Oracle Instance in Azure

Question

I want to resolve below problems:

• 1) Take Database dump from a Oracle Database(On Prem)
• 2) Create a Oracle Database in Azure
• 3) Place the On Prem Database dump file on BLOB storage and import the database in the Azure Oracle Database.

For creating database dump, i am trying to use SQL Developer Database Export utility. But struggling with the output format.

For Azure Oracle DB, i have deployed Oracle Standard 12.2 from MarketPlace, but don't know how to create a DB and import DB using BLOB storage DUMP file

Answer 1

You could use Copy Activity in Azure Data Factory.

It supports Oracle Database connector and Azure Blob Storage connector.

Here is an official detailed guide about transferring data from or to Oracle DB on-prem.