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

Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: Importing an Oracle 9i export file into Oracle 8.1.7

Re: URGENT: Importing an Oracle 9i export file into Oracle 8.1.7

From: nettdata <nettdata_at_noSpAM_nettdata.com>
Date: Wed, 17 Jul 2002 14:46:53 GMT
Message-ID: <3D358374.20405@noSpAM_nettdata.com>


Check out http://www.kiyoinc.com/nxtract.html for one of many such utilities.

Never say "none at all". ;)

Telemachus wrote:

> No.
> none at all.
> 
> connect the 817 database via SQLNET to the 9 and exp what you need - then
> import it into 8. There is NO other way to do it well there is - ctas x
> dblink ,replication,
> 
> 
> Can't resist : upgrade the 817 to 9 and then it'll work.... but that's
> cruel.
> 
> 
> "Sridhar" <sridhar_at_inapp.com> wrote in message
> news:ah3e3d$c53$1_at_news.vsnl.net.in...
> 

>>Hai All.
>>
>>Is there some API or tool somewhere which can read the export file and
>>convert it into ASCII SQL files....
>>
>>Sridhar
>>
>>
>>"nettdata" <nettdata_at_noSpAM_nettdata.com> wrote in message
>>news:3D35372F.5000409_at_noSpAM_nettdata.com...
>>
>>>I could be wrong, but I think that you have to do an export from the 9i
>>>database using the 8.1.7 export tool, and then import it into 8.1.7
>>>using the 8.1.7 import tool.
>>>
>>>I don't believe that 8.1.7 import tool can process the 9i export file,
>>>and I don't believe that 9i import will work on an 8.1.7 database.
>>>
>>>I would say that you have to install 9i somewhere and do an import into
>>>it, and then do an export with 8.1.7's export before it will work.
>>>
>>>
>>>$0.02
>>>
>>>
>>>...jeff
>>>
>>>
>>>Sridhar wrote:
>>>
>>>>Hai All
>>>>I have got an Oracle 9i Export Script, though i dont have an oracle 9i
>>>>installation.
>>>> I want to import that file into an Oracle 8.1.7 installation.
>>>>Please do Help me in this matter
>>>>This is ugent
>>>>
>>>>Sridhar
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>

>
> Received on Wed Jul 17 2002 - 09:46:53 CDT

Original text of this message

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