Re: Export/Import to tape?

bogreen_at_unixg.ubc.ca (Bo Green) writes:

> 1) I need to change the tablespace allocation of a large database I am
> working with, so I thought the best way would be to Export, create
> new tablespaces, and then Import the tables. Unfortunately, I don't
> have enough disk space to Export to disk. I figure out how I can Export
> to exabyte tape in a reasonably efficient way. Any ideas?

Looks like you are UNIX by your address, so here goes (1) Compressing export to disk

	mknod ora_export.dmp p
	nohup compress < ora_export.dmp > ora_export.dmp.Z &
	exp / ...... file=ora_export.dmp
	
	This lets you compress on the fly without using any disk (well,
	you will use 4 disk blocks or the size of a pipe).

(2) If exabyte takes streaming input could do the following
	change nohup line to not write to ora_export.dmp.Z but use
	dd(1) {sourcing from stdin} and output to tape.

Hope this helps

David T. Bath Email:dtb_at_otto.bf.rmit.oz.au Phone:03-3477511 Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA "Failure to emulate is the best revenge" - Marcus Aurelius

-- 
David T. Bath	Email:dtb_at_otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius