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

Daniel Morgan <damorgan_at_exxesolutions.com> wrote

> The solution, as less than elegantly discussed so far, is to sit down
> with your DBA and work together on a solution.

Elegant explanations never seenms to help Daniel. At least not in my experience. :-(

One has to drive the point home at times. Mercilessly and brutally. It worked pretty well in me infantry days. ;-)

> And the point of rules is to facilitate the organization's business. If
> this rule prevents you from doing your job find a work-around.
> One that comes immediately to mind is to have the DBA build what you
> need for you. Another would be to grant you CREATE TABLE
> for one hour or one day. A little imagination should present you with
> several more.

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.

--
Billy