Re: Import to another Server

On Thu, 21 Dec 2000 14:48:03 +0800, "chen" <marschen_at_hotmail.com> wrote:

>What do you really want to do?Have the other server had a oralce8i instance
>runing on it?
>
>
>"D. KHADER" <khader_at_rhrk.uni-kl.de> wrote in message
>news:91bj42$khb$1_at_sun.rhrk.uni-kl.de...
>> hi,
>> i cant solve this problem , it is importing an ORACLE8i Database from one
>> linux-Server to another Linux-Server .. how can i do that?
>> it is not possible to use ftp or telnet to send data ..
>>
>>
>> thanx
>>
>>
>>
>

If the computers exist on the same network and can talk to each other, then all you have to do is make sure the database is named in the TNSNAMES.ORA file. You can then use the following syntax on the box you are importing to as long as the versions are the same:

exp <user>/<pwd>@<other servers database> file=<file name>

Note the @<other servers database> is the database on the OTHER box. This will utilize sqlnet for the export and will copy across the network to the server you are on.

You should remember to use the full correct syntax for export. Once you have the .dmp file on the server you are importing to, then just perform the import.

I hope this helps.
Bob Received on Mon Dec 25 2000 - 23:00:58 CST