Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transportable Tablespace Backup Process.
Louis Frolio wrote:
> 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
Have you gone to http:tahiti.oracle.com and read the documentation? Have you tried it on a test box?
Why are you asking us?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri May 07 2004 - 18:28:39 CDT