Re: Unload to TAPE?

Gary Hale (hgary@eg570.egclassic.com) 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? Have you tried UNLOAD TO '/dev/rmt0' SELECT * FROM tabname ^^^^^^^^^ or other tape device However, I don't think unloading the data and rebuilding the table will get rid of this -271 error. The table will be just as big after you rebuild it as it was before. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.