Re: Transportable Tablespaces and Deferred segment creation "bug"

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Tue, 27 Nov 2012 16:51:28 +0000
Message-ID: <50B4EF90.4000907_at_dunbar-it.co.uk>



Evening Yong,

> ...
> I didn't know this was still a problem in case of transportable
> tablespace export, in version higher than 11.2.0.1(?).

My problem was with 11203, so yes, it's a problem.

I can't use expdp/impdp because that raises a separate problem. To do a TT impdp, you must have a database link pointing back from the receiving database to the source database. Out two databases were "air-gapped" so no network connections possible between the two.

Exp and imp work fine. For the TT and for the obtaining of the metadata to allow me to recreate the missing empty tables. At least in 11203 it is.

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 27 2012 - 17:51:28 CET

Original text of this message