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 > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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).
