RE: how to improve impdp

Thank you so much. You cleared my confusion. Yes, I queried dba_objects after I dropped the tables and views. I thought objects in recycle bin should be named like BIN$$.

Learned a new thing from this. Thanks again.

Joan

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Norman Dunbar Sent: Wednesday, July 17, 2013 4:48 AM
To: oracle-l_at_freelists.org
Subject: Re: how to improve impdp

Morning Joan,

On 16/07/13 21:39, Hsieh, Joan wrote:
> I have managed to drop all the tables and all views, it is much faster
> than drop user cascade. However, there are a lot of SYS_LOB%$$ LOBSEGMENT left. I couldn't find any drop statement to drop all these LOB objects. Does anyone know how?

I have seen this very problem on 11.2.0.3 numerous times. If you query DBA_OBJECTS then you will see the LOB Segments still present.

However, they are actually in the recycle bin, so:

purge dba_recyclebin;

if you are a SYSDBA type user will clear them out. If you are a normal users then

purge recyclebin;

will clear out the ones owned by your current user.

It drove me nuts for ages until I sat down and figured out where these things were actually "living" after I had dropped the tables. Funny thing was, I drop the tables with PURGE to bypass the recycle bin - but the LOBs seem to like the bin and stick around until purge time. I have no idea why this happens.

HTH 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


--
http://www.freelists.org/webpage/oracle-l