How to create an account on Oracle XE 18.x

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.

submitted by /u/AKDiscer
[link] [comments]

Author: Martin

Leave a Reply

Your email address will not be published.