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.
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
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 ?
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