Oracle 10g compressed export import

Sometime happens that I needed to export a database (either partially or ‘FULL’) not having enough disk free space available for all the operations: the export file by itself could barely fit into the few free disk space available so that I could not even think to compress it, because almost at the end of compression (gzip) the scenario would have been: export_file.dmp added to the almost 99.9% of the compressed export_file.dmp would

exceed the free disk space available.

The following examples show how to do an export into a compressed file (gzip) in one single step to avoid wasting disk space.

momo@cujox:~ $ mkfifo fifo_dbexport_20081119.dmp

momo@cujox:~ $

momo@cujox:~ $ nohup gzip < fifo_dbexport_20081119.dmp \
     > real_db_export_20081119.dmp.gz &

momo@cujox:~ $
momo@cujox:~ $ nohup exp \
     scott/tiger \
     tables=(TABLE_1, TABLE_2, TABLE_3) \
     FILE=fifo_dbexport_20081119.dmp \
     LOG=dbexport_20081119.log &

momo@cujox:~ $
momo@cujox:~ $ rm fifo_dbexport_20081119.dmp

 

The following examples show how to do an export into a compressed file (gzip) in one single step to avoid wasting disk space.

momo@cujox:~ $ mkfifo fifo_dbimport_20081119.dmp
 
momo@cujox:~ $ nohup gzip -d < real_db_export_20081119.dmp.gz \
     > fifo_dbimport_20081119.dmp &

momo@cujox:~ $ nohup imp \
     scott/tiger \
     tables=(TABLE_1, TABLE_2, TABLE_3) \
     IGNORE=Y \
     FILE=fifo_dbimport_20081119.dmp \
     LOG=dbimport_20081119.log &

momo@cujox:~ $ rm fifo_dbimport_20081119.dmp

I hope this was usefull

 

Lascia un commento

Tutti i commenti dovranno essere verificati ed approvati dal webmaster, prima di essere pubblicati

 

Quote of the Day

Si può esser tutto ciò che si vuole, basta trasformarsi in tutto ciò che si pensa di essere

Freddie Mercury

Chi è online

Abbiamo 319 visitatori e nessun utente online

Newsletter

Per essere sempre aggiornato sulle ultime novità.

Go to top