spool direct to the tape

From: byang <byang_at_vela.acs.oakland.edu>
Date: 1997/09/13
Message-ID: <Pine.OSF.3.95.970913163036.24455C-100000@vela.acs.oakland.edu>#1/1

hi, all:

I have to spool three tables to tape quartly. I use command

	spool dev/rmt/0
	select [column_name]
	from [table_name];

mostly it work fine. But recently it went wrong since some tape drive problem. I did not aware it before I ship it out. This delay our process several days.

        Is there existed a way to check if disk contain the exactly data from three table before shipping tape out?

        what I can think about is loading the table into disk, then convert the data file to a temporary table then compare it with the original one. sound too naive! and the problem is table is too huge to have enough disk space. for the small table, I also need help on command to load data file from tape to disk.

Thanks in advanced!!!

---

             Biao YANG         

---

Received on Sat Sep 13 1997 - 00:00:00 CDT