This discussion is archived
6 Replies Latest reply: Dec 5, 2012 2:11 AM by Sunny kichloo RSS

Export backup from 9i & restore in 11g

927253 Newbie
Currently Being Moderated
Hi im going to take bakup from Oracle 9i & resore in 11g R2, below are the exp command going to execute,what are the other necessary details i need to includeother than below

exp dlsri@sdld full=y file=/install/backup/full.dmp log=/install/backup/full.log

Please assit this
  • 1. Re: Export backup from 9i & restore in 11g
    Sunny kichloo Expert
    Currently Being Moderated
    Check this

    http://shanojkumar.wordpress.com/2012/05/23/oracle-exp-and-imp-oracle9i-to-11g/

    Also if you have Metalink support Check this

    Compatibility Matrix for Export And Import Between Different Oracle Versions [Video] [ID 132904.1]


    And if your issue is resolved you can close this thread as it save time for users looking for open questions
  • 2. Re: Export backup from 9i & restore in 11g
    927253 Newbie
    Currently Being Moderated
    Thanks it's very helpful
  • 3. Re: Export backup from 9i & restore in 11g
    Sunny kichloo Expert
    Currently Being Moderated
    So are you able to resolve the issues.
  • 4. Re: Export backup from 9i & restore in 11g
    927253 Newbie
    Currently Being Moderated
    Hi
    Sunny kichloo,

    Extremely sorry for late response, when im trying using this in our database according to your tablespace gather sql could not revive proper output

    select ‘create tablespace ‘ || df.tablespace_name || chr(10)
    || ‘ datafile ”’ || df.file_name || ”’ size ‘ || df.bytes
    || decode(autoextensible,’N',null, chr(10) || ‘ autoextend on maxsize ‘
    || maxbytes)
    || chr(10)
    || ‘default storage ( initial ‘ || initial_extent
    || decode (next_extent, null, null, ‘ next ‘ || next_extent )
    || ‘ minextents ‘ || min_extents
    || ‘ maxextents ‘ || decode(max_extents,’2147483645′,’unlimited’,max_extents)
    || ‘) ;’
    from dba_data_files df, dba_tablespaces t
    where df.tablespace_name=t.tablespace_name
    /

    Please follow this sql statement & are there any changes to do this,Please if there any changes to do please tell because im in stuck with this.
    Please advice need your assistance
  • 5. Re: Export backup from 9i & restore in 11g
    927253 Newbie
    Currently Being Moderated
    Please any one can update this, appreciate help
  • 6. Re: Export backup from 9i & restore in 11g
    Sunny kichloo Expert
    Currently Being Moderated
    Sorry for that script.

    It would be better if you just follow the steps i.e--

    Look on for Character Set as mentioned in the link.

    1)Create dump file backup of Oracle 9i database with the help of Oracle Export Utility.

    2)Then you can generate the user creation script and tablespace creation script from the source database.Actually depends on how many users are present in your database.If less you can use dbms_metadata to generate ddl

    how to get ddl of users and roles?

    3)Install The Oracle binaries and Create Oracle database and create users and tablespace from ddl generated from Oracle 9i database.

    4)After that try to do import

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points