Re: Extracting 2.5 million rows

From: hpuxrac <>
Date: Thu, 7 Jan 2010 05:10:01 -0800 (PST)
Message-ID: <>

On Jan 6, 7:46 pm, Cliff wrote:


> Hey all,
> I was looking for some guidance.  I need to do some stat analysis on a
> production audit table.  One problem is that there are no indexes on
> the audit table and spooling via sqlplus would take years.
> Using Export on the server, the disk space required for the dmp file is
> about 40 G ( per the DBA ).  This space is not available on the UNIX
> box.
> Would running EXP locally be a valid option?
> I realize that any solution is going to take a while of processing
> time; it's just that I don't want to get 100-hours in and then find a
> fatal flaw.
> Thoughts?
> TIA,
> Cliff

Test whatever you are going to do on a smaller system ( test system ) with a smaller amount of data first so that you know what your plan is.

Then start figuring out what will change and what else needs to be verified before doing this on a larger system.

I recommend that you work with your DBA and not some internet newsgroup on figuring out what your plan should be and coming to an agreement that includes a step by step planning and verification process. Received on Thu Jan 07 2010 - 07:10:01 CST

Original text of this message