A customer sent us a oracle database we have to test against. We do not use oracle or have oracle knowledge of house.
We have to setup the database therefore we can connect with it and debug an issue.
Used to do a brand new install of oracle 9 (the version the customer is running) and also the management tools.
I am unable to for that existence of me have it to import the information. It can't be this complicated. I have to receive a problem.
I have attempted:
C:oracleora92bin>imp 'sys/password AS SYSDBA' file=c:database.dmp full=yes log=implog.txt
and also got:
Attached to: Personal Oracle9i Release 9.2..1. - Production Using the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2..1. - Production
Export file produced by EXPORT:V09.02.00 via conventional path
Warning: the objects were released by SYSTEM, not on your part
import completed in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set . posting SYSTEM's objects into SYS . posting ABCDE's objects into ABCDE IMP-00003: ORACLE error 1435 experienced ORA-01435: user doesn't exist Import ended effectively with alerts.
But nothing turns up within the manager so far as tables in almost any schema and I am inside my wits finish.
It's not present with create tables as SYS or SYSTEM in Oracle, as individuals two accounts are managers.
Error implies that the consumer produced tables as user
You need to create that user before import, then you definitely should import data as that user,
This will get rid of the error because released file consists of permissions along with other informations associated with user
ABCDE that doesn't appear in database.
Take a look question for further hints: How to determine the Schemas inside an Oracle Data Pump Export file.
You will need to produce a user (or Schema) first
C:\>sqlplus system/password SQL> create user CLIENT_TEST identified by client_test_password; SQL> grant connect, unlimited tablespace, resource to CLIENT_TEST; SQL> exit
You'll be able to make use of the
touser= IMP switches to import the information in to the new user/schema:
C:\>imp system/password FROMUSER=ABCDE TOUSER=client_test file=c:\database.dmp full=yes
Hope that can help!
Did the customer supply the particulars of methods they produced the dump file? Particularly, are you currently sure that this can be a full export as opposed to a schema-level export, a tablespace-level export, or perhaps a table-level export?
You need to produce user "ABCDE"
Something similar to
create user ABCDE identified by password; grant connect, resource to ABCDE;
There is a squillion choices on "create user" but this could make use of the defaults.
Instead of 'sys/password AS SYSDBA', try 'system/password'.
Oracle's tool necessitates the same user to import as produced the export despite the fact that sys may be the "all effective" user.