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,

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-l
Received on Tue Nov 27 2012 - 14:54:43 CET

Original text of this message