Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How do IMP & EXP - SOS

RE: How do IMP & EXP - SOS

From: Rao, Maheswara <Maheswara.Rao_at_Sungardp3.com>
Date: Mon, 11 Jun 2001 06:13:01 -0700
Message-ID: <F001.003240CE.20010611061525@fatcity.com>

<SPAN

class=699111313-11062001>Deewaker,
<SPAN

class=699111313-11062001> 
You
did not mention what is the version of Oracle 8i.  I am assuming it is higher than Oracle 815.  In this case do the following steps.
<SPAN

class=699111313-11062001> 
1.
Take export of the schema using exp from Oracle 815.  To do this , you can connect to your source database using a connect string thru tnsnames.
<SPAN

class=699111313-11062001> 
2.
Once you have the dmp file, then use the imp of Oracle 815 to do import into Oracle 815.
<SPAN

class=699111313-11062001> 
<SPAN

class=699111313-11062001>Rao
<SPAN

class=699111313-11062001>Maheswara.rao_at_sungardp3.com

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Deewaker G.V.   [mailto:Deewaker_at_baazee.com]Sent: Monday, June 11, 2001 3:51   AMTo: Multiple recipients of list ORACLE-LSubject: How   do IMP & EXP - SOS
  hi
  I need to do the IMP of a dmp file
  from Oracle 8i to 8.1.5
  can you guys pls help me how to go
  about it
  with warm regards
  deewaker g v Received on Mon Jun 11 2001 - 08:13:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US