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.
imp 'sys/password AS SYSDBA' file=c:\database.dmp full=yes log=implog.txt
Connected to: Personal Oracle9i Release 22.214.171.124.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 126.96.36.199.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.