Re: Import Oracle 8 export file into an Oracle 7.3 db?

Hi,

    Did you try:

    CREATE PUBLIC DATABASE LINK o8
    connect to <user_id> identified by <password>     USING <database_alias>;

    CREATE TABLE <tbl_name> AS SELECT * FROM <tbl_name>@o8:

If you can create the database link I think you will find it faster than export and import.

regards
jerry gitomer

Tim Weiler wrote in message ...
>I know that importing a 7.3 export file into Oracle 8 is
possible, I've done
>it before, but I need to get data from an Oracle 8 db into an
Oracle 7.3 db
>and the two servers are on different networks, hence the export
file.
>
>
>Luca wrote in message <939225678.765499_at_tango.comm2000.it>...
>>I don't know if it's possible ...
>>I'm trying to import a Oracle 7.3 export file into Oracle 8 ...
>>There are some problems ....
>>
>>Bye
>>Luca.
>>
>>Tim Weiler ha scritto nel messaggio

<_iJK3.537$di5.21177243_at_interramp>...
>>>I have an Oracle 8 export file and I need to import it into a
7.3
>database.
>>>Is this possible? We have both Oracle 8 and 7.3 setup on our
network, but
>>>the Ora 8 db .exp file is from an external database.
>>>Any suggestions?
>>>Thanks,
>>>Tim
>>>
>>>PS Remove the '.remove' in my e-mail to e-mail me directly
>>>
>>>
>>>
>>
>>
>
>
Received on Tue Oct 12 1999 - 12:20:00 CDT