Re: import selectively transportable tablespaces

Marco Vannini wrote:
> Hi all. I have a problem in importing transportable tablespaces (Oracle EE
> 9.2.0.6)
> I made a transportable tablespace set (for backup purpose) containing 2
> tablespaces, and each of them is full self contained (no objects in tbs1
> refers to objects in tbs2).
> Now I need to plug-in (in the same database) only one of the tablespaces, so
> in the parfile, along with the datafiles, I specified only TBS2 in the
> TABLESPACES tag.
> Import Fails with ORA-29347: Tablespace name validation failed - failed to
> match tablespace 'TBS1'.
> Is there any way to avoid this error or I am forced to import both?
>
> Thanks.
>
>
>

Import both and then drop TBS1.

Another alternative is to create your metadata dump file separately for TBS1 and TBS2. In other words, create separate TTS sets. That way, you won't run into this problem.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown