Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: exp/imp to/from multiple compressed files ?

Re: exp/imp to/from multiple compressed files ?

From: Prem <premjhere_at_gmail.com>
Date: Sat, 15 Jul 2006 00:32:35 +0530
Message-ID: <56d3d5610607141202l1fe7c395yc99617dc41fffba@mail.gmail.com>


Brandol and All ,

But still i am desperately in need of a script which does that ? That is :
I need to export to multiple compressed files (on oracle 9iR2). And I need to import from multiple compressed files (without uncompressing). All because of space constraint.

Regards | Jp.

On 7/14/06, Prem <premjhere_at_gmail.com> wrote:
> Thanks Brandon.
> We are already in the mid of doing the same.
>
> Regards | Jp.
>
> On 7/14/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> > You could break up the exp into multiple exports by schema, or table
> > list - and then run each of those to its own compressed file. This also
> > gives you the additional benefit of allowing you to run multiple exports
> > and imports in parallel, which can significantly reduce the total time
> > required.
> >
> > Regards,
> > Brandon

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 14 2006 - 14:02:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US