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 ?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…