I am trying to import a DB into Oracle 9i, using hte Import Utility I ran into the following PBs:
[oracle@Linux2005 oracle]$ imp system/tiger FILE=/OraHome/080904.dmp FROMUSER=AL CIE FULL IGNORE=N
Import: Release 220.127.116.11.0 - Production on Thu Sep 9 19:47:11 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Release 18.104.22.168.0 - Production
JServer Release 22.214.171.124.0 - Production
Export file created by EXPORT:V08.01.05 via conventional path
Warning: the objects were exported by ALCIE, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversio n)
. importing ALCIE's objects into ALCIE
"ALTER SESSION SET CURRENT_SCHEMA= "ALCIE""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
I guess that I have to precreate an ALCIE user and then attempt another import ?
Should I jsut create a new virgin DB ?