6 Replies Latest reply: Dec 5, 2012 4:11 AM by Sunny kichloo RSS

    Export backup from 9i & restore in 11g

    927253
      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
          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
            Thanks it's very helpful
            • 3. Re: Export backup from 9i & restore in 11g
              Sunny kichloo
              So are you able to resolve the issues.
              • 4. Re: Export backup from 9i & restore in 11g
                927253
                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
                  Please any one can update this, appreciate help
                  • 6. Re: Export backup from 9i & restore in 11g
                    Sunny kichloo
                    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