Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Q: Oracle sqlplus way to capture all duplications and removal.

Re: Q: Oracle sqlplus way to capture all duplications and removal.

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Sun, 07 Sep 2003 08:24:07 -0700
Message-ID: <1062948229.652909@yasure>


Randy Harris wrote:

>I realize that it doesn't address the underlying political problems, but if
>this is a one time need... Why couldn't ColoC simply spool a SELECT DISTINCT
>to a file, TRUNCATE the table, then reload?
>
>
>

I can come up with several reasons. One being the size of the data set: It could easily be too large for that solution. The second being, as Billy points out, that you don't work-around political problems or they never go away. The OP needs to develop a mutually cooperative relationship with the DBA.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sun Sep 07 2003 - 10:24:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US