This discussion is archived
3 Replies Latest reply: May 7, 2012 5:43 AM by 368487 RSS

Transporting Tablespaces Across Platforms

368487 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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