Re: how to exp big table with 2GB file size limitation?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 14 Sep 2000 21:26:53 +0200
Message-ID: <968960699.1023.0.pluto.d4ee154e@news.demon.nl>

Basically
create a pipe with mknod
fork a process which calls gzip reading it's input from the pipe (gzip > [compressed file] < orapipe &)
exp your data to the pipe.
Your data will be compressed on the fly. Probably the compression factor is big enough to survive 10G (and usually that 10G isn't completel occupied anyway)

Hth,

Sybrand Bakker, Oracle DBA

"John Matzen" <krum(at)uo(d0t)com> wrote in message news:ss2868fdct671_at_corp.supernews.com...
> I'm running Oracle 8i on Solaris 2.7. How can I backup my 10GB of data
with
> exp if I have a 2GB file size limitation?
>
> Thanks!
>
> John
>
>
>
Received on Thu Sep 14 2000 - 14:26:53 CDT