Re: Unload to TAPE?
Gary Hale wrote:
>
> I need to unload a table to tape, this table is over a 1gig and I am
> unable at this time to create any more records (rows) in it? error
> 271! I would like to unload this data to tape and rebuild it. I am
> using 5.1 Informix SE on aix 3.2.5, how do I unload to tape?
>
> Gary Hale, IS Director
If you have the space available on disk, I would run the following:
temp=`mktemp`
touch $temp
tbunload -t $temp . . .
{ drop table }
tbload -t $temp . . .
...even better would be (assuming "orig" is table name):
create table mirror {use schema for orig};
insert into mirror select * from orig;{ create all indexes, procs, etc. }
drop table orig;rename table mirror to orig;
You should use a dbschema as a starting point.
--
+----------------+
| Dave K. Lahoti | == D4kLaho@PacBell.COM --- http://www.PacBell.COM
+----------------+