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.0309061225.6aebc083_at_posting.google.com>...
>
>
>>colocoloc_at_yahoo.com (ColoC) wrote
>>
>>
>>
>>>That's the point. Even though I do not have 10+ million, I have over
>>>500+k rows. And I am not the DBA who made the rule that a user (as I
>>>am) is not allowed to create any table in the DB. But I am asked to
>>>deal with the problem.
>>>
>>>
>>What you are asking for is a technical solution for a political
>>problem.
>>
>>Sorry. I don't deal or assist in crap like that.
>>
>>You and DBA are suppose to work *together*, for the *same*
>>organisation and for the *same* goals.
>>
>>If you, the DBA, and/or your respective management cannot under stand
>>that.. then tough shit.
>>
>>And yeah, political issues need harsh language as that is the only
>>language that is understood around the politics table. Not only here,
>>but in the real conference room when dealing with the empire building
>>arses.
>>
>>
>>
>
>Sorry for my words if it is not polite enough to guru in this group.
>And I do appreciate any better hint that could probably help me a
>little more.
>
>I am just not confident of myself at this time. However I always dealt
>with this type of craps here. Shit, isn't it? However please do back
>me and tell me whether my proposed solution is the only way I can do
>without any progress from the DBA's attitude if not say the DBA's
>knowledge or expertise. I just need some guru to tell me yes or no, OR
>ANY better ideas?
>
>Thanks.
>
>ColoC
>
>

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

As an end-user you can not solve this by yourself.

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.

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