Re: problem with 9i import

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

adary_at_mehish.co.il wrote:

  Well, I never check or set the oracle_sid.I just use userid/password_at_database and the import always go to the rightDB.On NT and win clients.Yechiel Adar, Mehish Computer Servicesadary_at_mehish.co.il   

    -----Original Message-----From: orantdba [SMTP:orantdba_at_netscape.net]Sent: Mon, January 14, 2002 11:15 PMTo: Multiple recipients of list ORACLE-LSubject: Re: problem with 9i importHI 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,JohnNew2orcl_at_aol.com 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: orantdba@netscape.netFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-