How to confuse developers
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: How to confuse developers

  1. #1
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    How to confuse developers

    Working late and thought I would open this thread, the need for which is long overdue. Let's get a list going.

    > Change synonyms so they point to wrong objects
    > Tell them there is something called exception handling
    I'm stmontgo and I approve of this message

  2. #2
    Join Date
    Jul 2003
    Location
    Sofia, Bulgaria
    Posts
    91
    -Make statstics on the half of the objects, next week delete them and make statistics on the other half
    -Delete the row in dual, or make dual in the schema of the developers with no row - when they come complaining, you will use sys.dual and all will be fine (for you)

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    For maximum confusion...

    -Be nice to them
    -Agree with thier ideas
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by stancho
    -Make statstics on the half of the objects, next week delete them and make statistics on the other half
    that's golden! how about a fucntion that gens stats randomly for each object on the hour
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    Well, here is a TRUE story that a project manager told me he did.

    One of our applications release requests was so asinine/insane that his DBA at the time actually broke down in his cube over this. He actually got permission from his Systems Manager to let them do whatever they wanted and not enforce ANY business rules or RDBMS restrictions on them; he removed the DBA department from the design process entirely and let them go for it.

    Needless to say they never made it past the first test phase and then humbly asked for our input into this release. Very funny and true!! I love know it all developers that think we are doing nothing but restricting them, let the lunatics run the asylum once in a while, why not?

    MH
    I remember when this place was cool.

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by stancho
    -Delete the row in dual, or make dual in the schema of the developers with no row - when they come complaining, you will use sys.dual and all will be fine (for you)
    I seem to remember two posts here - one had dropped dual, the other had managed to get two rows in it!

  7. #7
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

    Re: How to confuse developers

    Originally posted by stmontgo

    > Change synonyms so they point to wrong objects
    Add database link to the table definition in the synonym. In the remote database have zero rows in the table.

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Create a table csalled "table" with a column called "union", and a table called "union" with a column called "table",
    than ...
    Code:
    create view "view"
    as
    select "table" from "union"
    union all
    select "union" all from "table"
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width