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,
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-lReceived on Tue Nov 27 2012 - 17:51:28 CET