Help! How do I build an Oracle 9i database?

Discussion in 'OT Technology' started by airbrat, Oct 3, 2003.

  1. airbrat

    airbrat Swollen Member

    Joined:
    May 6, 2001
    Messages:
    4,883
    Likes Received:
    0
    Location:
    Vegas
    The boss wants me to build a db so I can start learning. Rather sending me to class I end up having the software loaded on my PC and now he wants me to build a db from scratch! Plus what makes it even worse is I have ZERO SQL experience :(

    I'm no computer idiot but this stuff is damn hard! There's thousands and thousands of documation alone!

    Please, if you can help or know of a great source to get started I would be grateful!
     
  2. RotorBalls

    RotorBalls Gonz

    Joined:
    Sep 8, 2000
    Messages:
    47,421
    Likes Received:
    19
    Location:
    RBWH
    good luck :rofl:
     
  3. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    did you get all the client tools installed on your machine also? Should be pretty easy through those programs.
     
  4. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    why oracle? why not mysql.

    i know and use both, so i dont really have a fav. just currious why.
     
  5. Scoob_13

    Scoob_13 Anything is possible, but the odds are astronomica

    Joined:
    Oct 5, 2001
    Messages:
    73,788
    Likes Received:
    38
    Location:
    Fort Worth. Hooray cowgirls.
    Have you ever used Access?

    Basically all table creation through a GUI is the same thing - you simply name the field, choose the type of field, and set the parameters for the field (default values, max value, etc.).

    Just go in, create a test database, and start messing around with it. Then, create your development database and simply copy over the fields and settings that you need, and whammo, you've got yourself a development database.
     
  6. airbrat

    airbrat Swollen Member

    Joined:
    May 6, 2001
    Messages:
    4,883
    Likes Received:
    0
    Location:
    Vegas
    I wish it was that damn easy. I cant even get the
    DB itself running right!
     
  7. Scoob_13

    Scoob_13 Anything is possible, but the odds are astronomica

    Joined:
    Oct 5, 2001
    Messages:
    73,788
    Likes Received:
    38
    Location:
    Fort Worth. Hooray cowgirls.
    Your best bet is probably to grab a step-by-step intro to Oracle from the book store and then work on progressing past that.
     
  8. CompiledMonkey

    CompiledMonkey New Member

    Joined:
    Oct 26, 2001
    Messages:
    8,528
    Likes Received:
    0
    Location:
    Richmond, VA
    Tell your boss you're not a DBA and have no idea how to do what he's asked. Even if you do manage to get one up and running, it won't be of any quality (no offense to you personally). Just building a database is not all a DBA does. There is much much more to the job. If this database will be important in any way to the business, the business will have one hell of a nightmare while you're using it.
     
  9. aphoric

    aphoric Even if god did exist, it would be necessary to ab

    Joined:
    Aug 29, 2003
    Messages:
    918
    Likes Received:
    0
    Location:
    Leaving Afghanistan
  10. Scoob_13

    Scoob_13 Anything is possible, but the odds are astronomica

    Joined:
    Oct 5, 2001
    Messages:
    73,788
    Likes Received:
    38
    Location:
    Fort Worth. Hooray cowgirls.

    He does raise a pretty valid point, and it reminds me of a pretty funny story.

    A company that I'm contracting for had their programmer create a SQL database quite some time ago, and it was actually his first one, so there's virtually no normalization in it. There's also close to 200 fields in the main table, and approximately 1/2 to 3/5 of the fields are blank/unused.

    The moral of the story is figure out the best way to do things while learning how to do something, so you don't screw the company over by having them have to hire guys like me to come in and fix things :fawk:
     
  11. CompiledMonkey

    CompiledMonkey New Member

    Joined:
    Oct 26, 2001
    Messages:
    8,528
    Likes Received:
    0
    Location:
    Richmond, VA
    :eek2:
     
  12. aphoric

    aphoric Even if god did exist, it would be necessary to ab

    Joined:
    Aug 29, 2003
    Messages:
    918
    Likes Received:
    0
    Location:
    Leaving Afghanistan
    Before creating a DB from scratch, you should learn the basics, like query, update, delete, join and such. That will help you get used to the way tables are supposed to look and you don't make so many stupid mistakes right off the bat. Start with mySql...
     
  13. HardTech

    HardTech hungry

    Joined:
    May 5, 2000
    Messages:
    28,103
    Likes Received:
    1
    Location:
    NorCal
    do you know about database design? you should take a class or something in the local college. We're learning Dababase Logic right now in my DB class. We're going to move onto Oracle and SQL after the first exam.
     
  14. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    db's.... ugh.

    i did alright in my database classes, but fuck i hated it. sql is easy, but its the design that i hate. normalization is easy (for the most part) but fuck it can get brutal with huge tables... and tahts why i hate databases. goood money if in though if u become a DBMA!
     
  15. kingtoad

    kingtoad OT Supporter

    Joined:
    Sep 2, 2003
    Messages:
    55,923
    Likes Received:
    11
    Location:
    Los Angeles
    SQL Tutorial: http://www.w3schools.com/sql/default.asp
    It will teach you the basics enough to create a database and do stuff with it! If you can get Oracle to install that is, hehe.

    If you are serious about this, you should take an introduction to SQL class, a Database Administration class, and a System Analysis and Design class.

    :bigthumb: I love that shit.
     
  16. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
     
  17. kingtoad

    kingtoad OT Supporter

    Joined:
    Sep 2, 2003
    Messages:
    55,923
    Likes Received:
    11
    Location:
    Los Angeles
    :rofl: I think for the most part it is the design.
     
  18. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    yeah. well i dont have to take any more of those classes. what i know about database managment and structure can keep my head above water :big grin:
     

Share This Page