Re: Load Data directly from Tape

Joseph Y. Suh (jsuh_at_randomc.com.usa) wrote:
: I would like to load a large amount of data using SQL*Loader. I
: normally do tar to disk from tape, then use SQL*Loader,but has
: insufficient disk spcae. How can I load data directly from Unix tape
: evice?
 

: Thanks. Joseph.

just use your tape address as the infile parm:

example: INFILE '/dev/rmt/td0' "fix 237"

REMEMBER TO USE THE TAPE COMMANDS TO POSITION THE TAPE AT THE FILE YOU WANT TO LOAD. You cannot address a specific file on the tape....just the tape itself.

The loader will try to load whatever file it is pointing to when it reads the tape. So if you want to load the second file do a mt dt0n command with the fsf 1 option to position the heads at file 2. Also, don't forget to use the 'no rewind' option when entering the tape command....in the above example 'dt0n' would mean tape drive dt0 with no rewind, as opposed to dt0 which would reposition the tape then automatically rewind it again.

hope this helps,
rick Received on Thu Mar 14 1996 - 00:00:00 CET