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

  • From: Prem <premjhere@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 15 Jul 2006 00:32:35 +0530

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@xxxxxxxxx> wrote: 
Thanks Brandon.
We are already in the mid of doing the same.

Regards | Jp.

On 7/14/06, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> 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

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2006