Re: problem with 9i import

[orantdba]

Proof that there is more than one way to skin a cat :-).  If new2orcl had done
what you suggested they wouldn't have a problem either :-).

John

[EMAIL PROTECTED] wrote:

Well, I never check or set the oracle_sid.
I just use userid/password@database and the import always go to the right
DB.
On NT and win clients.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

-----Original Message-----
From: orantdba [SMTP:[EMAIL PROTECTED]]
Sent: Mon, January 14, 2002 11:15 PM
To:   Multiple recipients of list ORACLE-L
Subject:  Re: problem with 9i import

HI New2orcl,

My guess is that your $oracle_sid was set to point to oem when you did 
the import with is why it imported into that database.  The only way to 
get it out is to log on to the oem database and drop each table.

To get it into the correct database set the oracle_sid and then do your 
import.

Good luck,
John

[EMAIL PROTECTED] wrote:

Hi,
I have recently installed 9i on my computer and wanted to import my

exdat.dmp 

file from my Oracel 8i. I got nowhere with the enterprise manager console

so 

after trying with no success through Oracle support I decided to try

doing 

the import from a command prompt. Well, I must have done something wrong 
because it imported the file but it put it in the  OEM database instead

of 

the ORCL and so my developer 6.0 does not have access to any of the

tables or 

data that I imported. Does anyone know the correct sintax to do the

import 

that I want to do and also how do I get it out of the OEM now? Have I

totally 

messed everything up?
Thanks

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-=-=-=-=-=-=-=-=-
 This e-mail was scanned by the eSafe Mail Gateway 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-