2 Replies Latest reply on Oct 3, 2013 9:42 AM by Hemant K Chitale

    Migration

    user10455042

      I am planning to migrate my 15 TB database from Solaris to Linux.  Below are my approach

      There are 100 schemas to migrate from Oracle 10g to Oracle 11g

      For Example: When I start Data Pump Export(schema wise) my SCN is 2343 and exported and imported from Source to Target db

      Can i take export from SCN 2344 using flashback_scan, and import into target db.  Will the target db will be in sync using this method?

        • 1. Re: Migration
          DK2010

          Hi,

          No, You can not Take Export from SCN, it only for upto date/SCN

           

          you can also check the Option  from here :Migration Of An Oracle Database Across OS Platforms (Generic Platform) (Doc ID 733205.1)

           

          HTH

          • 2. Re: Migration
            Hemant K Chitale

            It is quite likely that your export may fail to create a read consistent image of the data as of the SCN specified when it is attempting to export that volume of data, with transactions running concurrently.

            Since SPARC Solaris is Big-Endian and Intel Linux is Little-Endian, you'd have to convert the datafiles.

             

            Hemant K Chitale