Why are there no automation tools?



  • Ok, so I'm making this new application and I have to use Oracle.
    It makes no sense for me to mash out hundreds of lines of PL/SQL to do sequences / triggers / audit tables for all my tables or even reordering columns.
    THIS STUFF SHOULD BE AUTOMATED!!

    Where is a free tool that will do this for me?

    I've asked around the office and online and all the Oracle people just give me the stink eye like I'm some sort of idiot for wanting some basic automation to speed my job up. I miss my SQL Server 2005 DB :'(

    -Biff



  • Maybe you should spend less time bitching and more time understanding the tools you are expected to work with.

    From what I can gather you are trying to reimplement Oracle Total Recall the hard way.

    http://www.oracle.com/technology/oramag/oracle/08-jul/o48totalrecall.html

     

    rant:

    There is a reason some databases cost more than MySQL or Access you know.  They are packed full of features and have tools for a multitude of occasions, often designed by very clever people who know what they are doing.  Each database is different in a bazzillion ways.  Rarely is there a 1-1 conversion so you need to spend time learning at least something.  Sadly most people treat the high-end DBs like a copy of MS Access and badly re-implement all the features rather than use what comes with it, often citing the old 'database independence' 'requirement'.  I never undstood why organisations tolerate their developers and products not knowing and using every last feature of something that costs that much money.  It's kind of like buying a quad core 100TB RAID, blah blah top of the range server then giving it to the receptionist to play solitaire and email phone messages.

     Sorry - I've hijacked your thread to have a rant.  It's not just you (and not just Oracle, although it seems to be more widely misunderstood).

      /rant

    Oh, and fuck knows why you would want to 'reorder' your columns.  Reorder your select statements - it's the only thing that makes any sense.



  • @LoztInSpace said:

    Oh, and fuck knows why you would want to 'reorder' your columns.  Reorder your select statements - it's the only thing that makes any sense.
    <font face="courier new,courier">select * from....</font>probably.



  • I seriously don't know what the problem is with you Oracle people.
    Every forum I post on every DBA I ask all I get is hostility.
    You say this "high end database" has tons of features but none of them do what I want to do.
    And I don't want to have to maintain a flashback archive on top of my existing schema. I just want some damn audit tables.

    So eff it. I already made a program to do what I want to do and I know now to never ask an Oracle person about anything cause they don't know jack.



  • Well from your description it looked like you needed the Total Recall feature.  It is not 'on top of' but 'part of'.  I suspect you've impressed yourself with this solution and are reluctant to let it go even in the face of better ones.

    Anyway, if you already have the app then where are your DB scripts?  You either have it or you don't.

    Oh - and I'm not a DBA or affiliated with Oracle.  Nor have I used it for 4 years.  SQL Server all the way now.



  • @BiffMaGriff said:

    I already made a program to do what I want to do and I know now to never ask an Oracle person about anything cause they don't know jack.
    This sounds like it has front page potential.



  • @boomzilla said:

    @BiffMaGriff said:
    I already made a program to do what I want to do and I know now to never ask an Oracle person about anything cause they don't know jack.
    This sounds like it has front page potential.

    Cynic.

     (Then again, you should be asking their successor...)



  • @BiffMaGriff said:

    I seriously don't know what the problem is with you Oracle people. Every forum I post on every DBA I ask all I get is hostility.

    If your attitude was less hostile towards Oracle and indicative of actually having a question after doing some research rather than just ranting about things you don't understand, you'd get a lot less hostility in return.
    Not that there was much so far of course, the very first response told you where to look for answers rather than telling you where to stuff it which would possibly have been a more appropriate response to your rant (and the hostility you claim to experience).



  • @BiffMaGriff said:

    I seriously don't know what the problem is with you Oracle people.
    Every forum I post on every DBA I ask all I get is hostility.
    You say this "high end database" has tons of features but none of them do what I want to do.
    And I don't want to have to maintain a flashback archive on top of my existing schema. I just want some damn audit tables.

    So eff it. I already made a program to do what I want to do and I know now to never ask an Oracle person about anything cause they don't know jack.

     The problem with Oracle people is we hate you more than we hate Oracle... Quite simple... 🙂  Enjoy



  • @Wooly said:

     The problem with Oracle people is we hate you more than we hate Oracle... Quite simple... 🙂  Enjoy

    Well I'm not interested in making Oracle my lover. I'm interested in making Oracle my slave. 🙂



  • @BiffMaGriff said:

    @Wooly said:

     The problem with Oracle people is we hate you more than we hate Oracle... Quite simple... 🙂  Enjoy

    Well I'm not interested in making Oracle my lover. I'm interested in making Oracle my slave. 🙂

     Better creatures have tried and failed. All ended up being enslaved by the Oracle instead. Submit now and spare yourself the pain of forced induction by accepting your fate and the voluntary indoctrination program instead.



  • @BiffMaGriff said:

    I'm interested in making Oracle my slave.
     

    Uncle Larry in a gimp mask... ooooo <shiver>

    Can you get a mask for a chin that big?  The beard must add atleast 20 feet onto that upside himalayan fur peak.... hahaha


Log in to reply
 

Looks like your connection to What the Daily WTF? was lost, please wait while we try to reconnect.