3 Replies Latest reply: May 7, 2012 7:43 AM by 368487 RSS

    Transporting Tablespaces Across Platforms

    368487
      Hi Folks

      I need transport a full user schema, from production to developer database.
      In production --> Linux system operation
      In developer --> Solaris
      Both databases are 10G R2

      The schema that we will import, uses 2 tablespaces only is 500GB ( have some +-30 datafiles ).

      I think use Oracle transportable tablespace to do this is a good way.
      My doubts.
      In Export:
      When export the schema, use tranportable tablespaces, first do the exp with the datafiles that we want.
      After use the rman to convert the datafiles
      Is correct ?

      In developer database
      My doubts.
      I already have the same schema, I need clean up this to import the "refresh" from production.
      Do a drop the schema or drop only the tablespaces and datafiles?

      Copy the datafiles from production to developer, and run import of metadata generated during the export.

      How we will import the data of "grants,synonyms,etc" from "system", that this owner schema that we did the transport will need ?

      Tks
        • 1. Re: Transporting Tablespaces Across Platforms
          934481
          Hi

          what your exact doubt, if you want how to do that means i will help on that.

          Thanks
          Bharath
          • 2. Re: Transporting Tablespaces Across Platforms
            934481
            on production side

            first create one directory on oslevle.
            same in database level

            check that for which paltform you want to export.

            select * from v$transporatable_platform;

            whether your tablespace is exportable or not check

            exec dbms_tts.transport_set_check('tablespacename', TRUE);

            and then check the os space while exporting.

            before exporting set the streams_pool_size=10% of shared pool size because you are transporting across platforms.
            exp dp directory=directory name dumpfile= filename.dmp logfile=logfile.log transportable_tablespaces=tablespacename

            / as sysdba


            ------------------------------------------------------------------------------------------

            go to dev location

            mkdir in os level

            same in database level

            copy all the dumpfile , datafiiles to that directory.

            create the sufficient users which you want.


            imp dp directory=dirname dumpfile= logfile= transportable_datafiles=this datafiles location


            / as sysdba


            i think this will help you
            • 3. Re: Transporting Tablespaces Across Platforms
              368487
              Hi Bharath,

              In developer database
              My doubts.
              I already have the same schema, I need clean up this to import the "refresh" from production.

              Do a drop the schema or drop only the tablespaces and datafiles?
              How we will import the data of "grants,synonyms,etc" from "system", that this owner schema that we did the transport will need ?

              Tks