A client sent us a oracle database we need to test against. We don't use oracle or have any oracle expertise in house.
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.
I cannot for the life of me get it to import the data. It cannot be this complicated. I must be getting something wrong.
I've tried:
C:\oracle\ora92\bin>imp 'sys/password AS SYSDBA' file=c:\database.dmp full=yes log=implog.txt
and got:
Connected to: Personal Oracle9i Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.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.