Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Unanswered: DB2 to Oracle - DBA learning curve

    Hi guys: I have recently been asked to start supporting some of the Oracle databases we have in the organization. Currenlty I only have very little knowledge of the basic oracle concepts but I guess now I have to know it inside-out.

    Some of the fellow members on this forum, I am sure might have went through the same and trying to understand what is an instance, SID, PFILE and all those types of startup questions and how the hell you create, name an instance? and how can I create multiple instances/databases on a server?...lot of questions

    Anybody out there willing to share their exprience please do and if you can point to some good documentation that would be just wonderful.


    dollar

  2. #2
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    The tricky thing in the multi-database environments is that one is quite eager to expect things to be similar , while actually there is some much difference. I would suggest doing some training in fundamentals to get the 'grip' of the new RDBMS.
    Also look around for papers on migration, these tend to discuss the differences quite extensively .........
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    This topic has been discussed earlier, and some kind soul wrote a document comparing the two systems:

    http://www.dbforums.com/showthread.php?threadid=834802

    Also, "Oracle Concepts" manual makes a good reading. You can find it at otn.oracle.com (free registration needed). Another good resource is asktom.oracle.com.

  4. #4
    Join Date
    Mar 2004
    Location
    Athens, Hellas
    Posts
    3
    I have worked for a while on porting code from Oracle to DB2 and always found this guide usefull:
    Attached Files Attached Files

  5. #5
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Originally posted by kcb
    I have worked for a while on porting code from Oracle to DB2 and always found this guide usefull:
    Brilliant!
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  6. #6
    Join Date
    Jan 2004
    Location
    UK
    Posts
    52

    Thumbs up Re: DB2 to Oracle - DBA learning curve

    This might also help. I used this doc to understand DB2.

    http://www-106.ibm.com/developerwork.../dm-0401gupta/

Posting Permissions

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