Look at http://www.oriole.com for PDQOUT. It might be what you need at a low
cost.
-Original Message-
Sent: Tuesday, March 26, 2002 21:29
To: Multiple recipients of list ORACLE-L
Also look into the option BUFFER in export.
Srini
-Original Message-
Sent: Tuesday, March 26, 2002
t; cc:
Sent by: Subject: RE: EXPORT FAST?
root@fatcity.
Seema Singh wrote:
>
> Hi
> one of export for 35GB database is taking 12 hours.How to reduce this export
> time.
> Thx
> Seema
>
Try direct=Y, and (if nobody is currently using the database, otherwise
you risk running into inconsistencies) try to export in parallel, by
exporting several owners
Also look into the option BUFFER in export.
Srini
-Original Message-
Sent: Tuesday, March 26, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L
I think you can use direct=y option.
Are you taking this export to a file (over disk) or directly to tape?
Greeting
Diego Cutrone
---
FAST EXPORT:
1. High Buffer
2. Have export on a disk where you have less activity of i/o
3. Do Not Export to a NFS mounted file system/disk , which is very slow.
Hope this helps
---
Madhu
-Original Message-
Sent: Tuesday, March 26, 2002 12:13 PM
To: Multiple recipients of li
Make sure you didn't issue consustent=y and refer to
meta link for any problems with direct export on your
platform. Direct is the way to go.
Cheers,
RS
--- Diego Cutrone <[EMAIL PROTECTED]> wrote:
> I think you can use direct=y option.
>
> Are you taking this export to a file (over disk) or
> d
do this:
exp usr/pass buffer=4096 file=xx log=xx owner=xx. It takes 2 hours for
a 59GB's database.
-Original Message-
Sent: Tuesday, March 26, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
Hi
one of export for 35GB database is taking 12 hours.How to reduce this export
I think you can use direct=y option.
Are you taking this export to a file (over disk) or directly to tape?
Greeting
Diego Cutrone
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 3:13 PM
> Hi
> one of export for 35GB da
Hi
one of export for 35GB database is taking 12 hours.How to reduce this export
time.
Thx
Seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.c