A client sent us an Oracle database we need to test against. We don't use Oracle or have any in-house Oracle expertise.
We need to setup the database so we can connect to it and debug a problem.
I did a fresh install of Oracle 9 (the version the client is running) and the management tools.
For the life of me, I cannot get it to import the data. It should not be this complicated. I must be getting something wrong.
imp 'sys/password AS SYSDBA' file=c:\database.dmp full=yes log=implog.txt
Connected to: Personal Oracle9i Release 18.104.22.168.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 22.214.171.124.0 - Production Export file created by EXPORT:V09.02.00 via conventional path Warning: the objects were exported by SYSTEM, not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set . importing SYSTEM's objects into SYS . importing ABCDE's objects into ABCDE IMP-00003: ORACLE error 1435 encountered ORA-01435: user does not exist Import terminated successfully with warnings.
But nothing shows up in the manager as far as tables in any schema and I'm at my wits end.