Transportable Tablespace Backup Process.

Greeting All, here is my question.

If I do a TTS backup of say 10 tablespaces and they are all self contained can I plug only of them into another database or do I have to plug them all in? When I do the export I list out the tablespaces I want to transport:

exp userid=\"sys/pass as sysdba\" file=/tmp/tts_backup.dmp transport_tablespace=y tablespaces=pat_claim, lou_claim statistics=none

If I want to import both the tablespaces the import statement would look like:

imp \"sys/pass as sysdba\" file=/tmp/tts_backup.dmp transport_tablespace=Y
datafiles=/oracle/oradata/tprod/PAT_claim01.dbf, /oracle/oradata/lou_claim.dbf statistics = none

The gist of my question is what if I only wanted to import lou_claim.dbf, what would the import statement look like? I tried with:

imp \"sys/pass as sysdba\" file=/tmp/tts_backup.dmp transport_tablespace=Y datafiles=/oracle/oradata/lou_claim.dbf tablespaces=LOU statistics = none

and it failed because it tried to import PAT_CLAIM as well and the target DB was not prepped with the appropriate SCHEMA information for that tablespace.

Any help would be greatly appreciated.

L Received on Fri May 07 2004 - 15:27:13 CDT