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
|
||||
|
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
|
||||
|
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
|
||||
|
complete