Giuseppe’s Weblog

Just another WordPress.com weblog

Oracle imp exp con file compressi

lascia un commento »

Export

mkfifo exportFIFO.dmp

nohup exp scott/tiger tables=(EMP, DEPT) file=exportFIFO.dmp&

nohup gzip < exportFIFO.dmp > export.dmp.gz&

Import

mkfifo importFIFO.dmp

nohup gzip -d < export.dmp.gz > importFIFO.dmp&

nohup imp scott/tiger fromuser=scott touser=scott ignore=Y file=importFIFO.dmp&

Written by gfiorito

Giugno 12, 2008 a 10:34 am

Pubblicato in HowTo, Oracle

Lascia un commento