Re: Extracting 2.5 million rows
Date: Thu, 7 Jan 2010 03:44:35 +0000 (UTC)
Message-ID: <pan.2010.01.07.03.44.35_at_email.here.invalid>
On Wed, 06 Jan 2010 19:46:45 -0500, 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?
Locally? Running EXP is illegal in Texas. What do you mean by locally?
>
> 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.
You can run exp on another machine and connect over the TCP connection. The client exp executable must have the same major version number as the database server. There are even problems there: 9.2.0.1 exp file cannot export 9.2.0.8 database. Also, be aware of the different NLS conventions on Winduhs and Unix.
-- http://mgogala.byethost5.comReceived on Wed Jan 06 2010 - 21:44:35 CST