Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Q: Oracle sqlplus way to capture all duplications and removal.
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