RE: EXPORT FAST?

2002-03-29 Thread Hatzistavrou Giannis
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,

Re: EXPORT FAST?

2002-03-26 Thread Diego Cutrone
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

RE: EXPORT FAST?

2002-03-26 Thread Anne Yu
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

Re: EXPORT FAST?

2002-03-26 Thread Sakthi , Raj
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

RE: EXPORT FAST?

2002-03-26 Thread Reddy, Madhusudana
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

RE: EXPORT FAST?

2002-03-26 Thread SRAJENDRAN
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

Re: EXPORT FAST?

2002-03-26 Thread Stephane Faroult
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 or

RE: EXPORT FAST?

2002-03-26 Thread Rajesh . Rao
: Sent by: Subject: RE: EXPORT FAST? root@fatcity. com