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?
"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
news:1062908193.133753_at_yasure...
> 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)
>
>
Received on Sun Sep 07 2003 - 00:03:09 CDT
