Re: Transportable Tablespaces and Deferred segment creation "bug"
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Tue, 27 Nov 2012 13:54:43 +0000
Message-ID: <50B4C623.4010302_at_dunbar-it.co.uk>
Hi Pier Paolo,
Date: Tue, 27 Nov 2012 13:54:43 +0000
Message-ID: <50B4C623.4010302_at_dunbar-it.co.uk>
Hi Pier Paolo,
On 27/11/12 08:31, pier paolo Bruno wrote:
> ... What i was suggesting you is to make in 2 steps
> , first usual transportable tablespace step and then an expdp of the
> metadata only of the full database and an import of the metadata_only on
> the new instance after you import and make writable the transported
> tablespace. In this way it should recreate the tables you miss with no
> segment. With imp exp I don't think this works .
I ended up running an exp of the tables in the source database, with rows=n (which makes no difference as they are empty anyway) and importing that using imp which worked.
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 - 14:54:43 CET