Search: For:
Browsing Single Category

Using UNIX pipe to compress output while exporting

Topic ID: 342
Created By: 2004-FEB-05 07:14:18 [Gregmceachern]
Updated By: 2004-FEB-10 06:41:33 [Gregmceachern]
Status: Closed
Severity: Normal
Read Only: No
1282
2004-FEB-05 07:14:18
User
 
 
Registered On: Mar 2006
Total Posts: 4
When you don't have enough disk space available to perform an uncompressed 
export, you need to simultaneously compress the dmp file while the export is 
running.  To do this in UNIX, use the pipe.

For example.

mknod exppipe p
echo USERID=user/\password> PARFILE
echo FILE=exppipe >> PARFILE
echo GRANTS=N >> PARFILE
echo INDEXES=N >> PARFILE
echo ROWS=Y >> PARFILE
echo BUFFER=4096000 >> PARFILE
echo direct=y >> PARFILE
echo consistent=y >> PARFILE
echo triggers=n >> PARFILE
echo compress=n >> PARFILE

compress < exppipe > export.dmp.Z &
exp parfile=PARFILE



[edited by: Vitaliy at 21:51 (CST) on Apr. 06, 2006]
1283
2004-FEB-09 21:03:10
User
 
 
Registered On: Mar 2006
Total Posts: 143
Thanks Greg,

If anyone else has other examples of using UNIX pipe to compress output 
while running export or import please post here.

SW:
   exp imp pipe space large file mknod compress
1284
2004-FEB-10 06:41:33
User
 
 
Registered On: Mar 2006
Total Posts: 4
complete