I've searched far & wide for answers to this, but nothing I've found has worked. I'm a new Oracle user & just installed Oracle 11g express edition (11.2.0). I received a database export from an Oracle 11g database as a dump file (.dmp). I'm trying to read this file into an Oracle database to work with the data. There was apparently no other way for me to access the data in this .dmp file other than installing Oracle. I'm going to need to migrate the entire database (all tables & data) to a different format so that my team can actually work with it; I need to get this database from a .dmp to a .dbf file. This has proven to be challenging, and I cannot find any single resource that works. Is this really this complicated?
So, where in the world do I start? I can login under the "SYSTEM" username with DBA privileges (I'm assuming). I've created a new user, and I've tried to specify that new user as the DBA via SQL command line. This hasn't worked.
SQL> GRANT DBA to <usernamehere>
Do I even need to do this? All I want to do is bring in this dump file and (hopefully) move the data elsewhere as a .dbf file (or some file format that I can open outside of Oracle). How do I complete this simple task?
I've tried the imp and impdp commands to no avail. This is my first time using command line so I wouldn't be surprised if I'm doing something wrong or if I'm missing something here.
And here's the command line code I've tried...
imp 'SYSTEM/mypassword AS SYSDBA' file=c:\USERS\mynamehere\database.dmp full=yes log=implog.txt (I get an IMP-00058 error & ORA-01031 insufficient privileges; I think I rectified the privileges issue, then I received IMP-00038 could not convert to environment character set's handle error)
Also tried this... imp userid=username/password@importdb_tns file=export.dmp log=import.log full=y statistics=none
And I've also tried this... Cmd > impdp userid=SYSTEM/mypasswordhere dumpfile=C:\Users\bwasser\database.dmp logfile=impdp_export.log full=y directory=export
And I felt that I was getting closer with this... CMD> impdp userID=SYSTEM/mypasswordhere file=database.dmp log=import.log full=y statistics=none
but it threw a set of errors (ORA-39000 bad dump file specification; ORA=31640 unable to open dump file "C:\oraclexe\app\oracle/admin/xe/dpdump/database.dmp" for read)
I'm very suspect of that file path with forward and backwards slashes.
The .dmp file is located here (and I can move it elsewhere if need be): C:\Users\mynamehere
And I'm sorry if this is an elementary post, but I've expended all of my apparent resources (including searching this forum), so I'm now here before you.
Thank you,
Ben