Re: Export to Tape - How?
From: Madhu Aiyappen <madhu>
Date: 1996/01/17
Message-ID: <4dj71l$2lk_at_radon>#1/1
Date: 1996/01/17
Message-ID: <4dj71l$2lk_at_radon>#1/1
The one reason why you want to do this is to save disk space. Also If you are on a Unix system, you have a 2G limit on file size. If you are exporting a table over 2G, you can export to a pipe and compress the output on the fly. I have seen 60-80% compression on file.
step 1: /etc/mknod <pipename> p
step 2: use this pipename as export file.
step 3: compress < pipename > newfilename.
# now your exported data is in newfile name.
When you want to import do the reverse.
- mknod pipename p
- uncompress < newfilename > pipename
- use pipename for import file.