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

ColoC wrote:

>vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0309070225.ff2b0e_at_posting.google.com>...
>
>
>>Daniel Morgan <damorgan_at_exxesolutions.com> wrote
>>
>>...
>>
>>Exactly. If the OP's brief is to solve the problem, then presenting
>>the very simple idea (of doing a CREATE TABLE plus SELECT DISTINCT) is
>>exactly within the scope. And if he does not have the Oracle rights to
>>do it (which does make sense if this is a production environment),
>>then a standard Change Control procedure is in order, using the
>>assistance of DBA to get the job done. Together.
>>
>>This Us Versus Them attitude that seems prevelant in many IT
>>departments is just plain stupid. And should be dealt with swiftly.
>>With a lead pipe and harsh words if needed.
>>
>>
>>
>
>
>Sorry again. Some background for your reference is that I have been
>trying polite and harsh words towards _them_ (remember I did not name
>_them_ at the very beginning) in these sorts of issues for years. The
>result is that _they_ became more and more reasonable in the eyes of
>the higher management. And now it is so tough for me to find any other
>jobs even though I believe that I know more and can do better than the
>current DBA.
>
>So please, again, if anyone could possibly agree with my idea of doing
>it in files? -- I do not think "spool-select distinct" will even do
>it, because I only told you that the duplication-affected portion
>might be about 500+k rows, I did not tell you that the big table
>should be millions of rows altogether.
>
>Thanks.
>
>ColoC
>
>p.s. -- See this signiture -- I am terrified by the facts and truth
>that big companies never care.
>
>

You didn't have to which is why I answered Billy as I did earlier in the thread.

I have to confess a certain degree of exasperation with this thread. More time and effort have been spent trying to find a work-around to a very simple problem than the problem is worth. If you and your DBA can't work cooperatively together to solve a business problem one of you should polish up your resume and leave because what you have is a hostile work environment.

-- 
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)