Import process streamlining 1

[vivekm]

Hi,

I am importing data from Tandem to Oracle database. There are two questions related to the import.
Firstly, the import file will be sent across a network which may potentially be slow and/or the files will be very big. Is there a way of sending this file into Unix without using FTP?
Secondly, during import, if the process fails, is there a way to restart from the point of failure?

Thanks in advance,
Vivek

 

[MikeLacey]

Vivek,

Yes, there is a way of doing this.

exp(ort) your data to a fifo

on the fifo you need a command that will compress the datastream and then use remote shell to transfer it to your target machine, uncompress it there and save it to a file.

I haven't done this in ages but the commands will be something like this:

mkfifo in_and_out
(compress < in_and_out | remsh targethost 'uncompress > file.dmp') &
# then exp(ort) the database to the fifo in_and_out
# instead of a file, can't remember the syntax, sorry

you will first need to make sure that rlogin is set up correctly -- test your configuration with another command, like this:

[tab]remsh targethost 'ls -'
Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.