Re: Extracting 2.5 million rows

From: <Cliff>
Date: Sat, 9 Jan 2010 12:02:23 -0500
Message-ID: <>

On 2010-01-06 19:46:45 -0500, Cliff said:

> 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

Thanks for everyone's responses. I did find out that 2.5 million is for one of the test environments; production has 390 million. Luckily, I plan only to extract from 2005 through 2009 receiving a new total of about 15 million.

I have been working with one of our DBAs and I'm definitely go through a Proof of Concept with just a month's worth of data to get all of the network stats and ora segment effects. I've also engaged one of our SAS programmers to help with the stats.

My original post was to just get some ideas as my active Oracle days are back with version 7.. <No jokes please>

Thanks again,
Cliff Received on Sat Jan 09 2010 - 11:02:23 CST

Original text of this message