Hello all!
I'll start off by saying I'm completely new to Oracle database administration. My whole life has been spent in the Microsoft world, so I'm really familiar with the SQL Server family.
I recently was asked to get an Oracle instance up and running, and restore a data file. We ended a contract with a company that held our data, and they were using Oracle 12c. They provided us our data via Data Pump (.dmp) file for us to access.
I have installed Oracle XE 18.4 (on Windows Server 2012 R2) but have no idea to how to manage it. I figured it would be as easy as using SQL Developer, like use SSMS in SQL Server to restore the database....that doesn't seem to be the case! It appears that I need to use SQL Plus from the CLI to do this?
Also, can I take a data file from 12c and restore on XE 18.4 without an issue or special case(s)?
I've poked around on the Net, watched YouTube videos, and other things with nothing to show for it, save more confusion.
My end goal is to get this database restored so that I cause SQL Server Integration Services (SSIS) to munch, translate, and migrate the data to a SQL Server database.
See the following screenshot for my feeble attempts.
https://i.imgur.com/xlZoXF5.png
Message was edited by: 2948047