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 -- //www.freelists.org/webpage/oracle-l