Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2011
    Posts
    25

    Unanswered: How to Migrate Database From Oracle 6i to 10g ?

    Hi,

    I want to Migrate database from oracle 6i to Oracle 10g.
    Database is near about 25 GB and having nearly 150+ tables.

    Which Steps I have to follow?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by Mr.Vivek View Post
    Hi,

    I want to Migrate database from oracle 6i to Oracle 10g.
    Database is near about 25 GB and having nearly 150+ tables.

    Which Steps I have to follow?
    why upgrading from one obsoleted version to another obsoleted version?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2011
    Posts
    25
    It's Client's requirement .

  4. #4
    Join Date
    Nov 2003
    Posts
    2,932
    Provided Answers: 12
    There never was an Oracle version named "6i", the first version to contain the "i" was 8
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  5. #5
    Join Date
    Dec 2007
    Posts
    253
    Quote Originally Posted by Mr.Vivek View Post
    It's Client's requirement .
    Ask the client why they want to upgrade their database to an obsolete version of Oracle..

  6. #6
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1
    Why would a customer requirement care how the 'version' of the database engine stores / queries their data. I can't see what application(s) / requirements couldn't run on 11g/12c but can on 10g. This sounds like a made up customer requirement.

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by Mr.Vivek View Post
    Hi,
    I want to Migrate database from oracle 6i to Oracle 10g.
    Database is near about 25 GB and having nearly 150+ tables.
    Which Steps I have to follow?
    1) Reverse engineer the database to obtain the physical design (scripts).
    2) Create new 11g database
    3) Using the scripts, create the schema's (users) and tables.
    4) Dump the tables to csv files.
    5) Load the tables into newly created database.

    -- Or (maybe this will work) --

    1) Create new 11g database
    2) Use the v6 exp catalog scripts to create the export tables in new db
    3) Using exp v6, do schema(s) export from 6 and import to 11g

    Say a prayer.


    PS: As DBA your responsibility is to recommend migration to the latest or at least version to 11g
    .
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Maybe I'm reading it incorrectly, but it seems that we have 2 questions here:
    • how to migrate database (whose size is 25 GB and this schema contains 150 tables) from unknown version to 10g
    • how to migrate a Forms 6i application to Forms 10g


    The first part of the job could be done using EXP/IMP utilities (using source database's EXP version to export that schema, and target database's IMP version to import it), while application migration requires recompilation of all libraries, forms and reports (which is probably a simple part of the job), as well as installing and configuring application server in order to deploy that application to web (which promises to be the most difficult task here).

Tags for this Thread

Posting Permissions

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