Re: Exporting large (>8 gig) database in UNIX?

Simon Quinn wrote:
> What is the best way to do a full export on an ORACLE database on
> UNIX?
>
> The current file size limit on the version we are using is 2Gigabytes
> and I estimate the database will be 8 Gig in size.

1. create named pipe "expipe"
2. start exporting to "expipe" file
3. start compress from the "expipe" pipe to a file
4. enjoy on-the-fly compression to 20-30%

Details in several FAQs.

If that doesn't fit to 2Gb...

• directly to tape
• several exports (user mode, table mode)

-- 
== Lassi Salo, Nokia Telecommunications, 
== P.O.Box 33, FIN-02601 Espoo, FINLAND 
== Mail: lassi.salo_at_ntc.nokia.com 
== Nokia's Home: http://www.nokia.com/