Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: exp/imp to/from multiple compressed files ?
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-lReceived on Fri Jul 14 2006 - 14:02:35 CDT