I’m a M$ SQL DBA and I’ve been thrown a task to import a .dmp file. We have zero Oracle in our shop and I’ve never worked with Oracle. Well, I did over 15 years ago and it wasn’t in a professional setting.
Anyway, I have installed Oracle XE 18 and SQL Developer, and I’m having a helluva time importing this .dmp file, which is about 5GB. No matter what I do, I keep getting an error about having a wrong user name and password. I did set the PDBADMIN account during installation, but nothing I do allows me to use the account.
Does anyone have any tips or a guide that show me the process? This is a one-time thing, so it’s going to be a permanent setup.
EDIT: This is installed on Windows Server 2012 R2.