Re: how to improve impdp
- From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Jul 2013 09:48:07 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » how to improve impdp- Hsieh, Joan
- » Re: how to improve impdp- rjamya
- » Re: how to improve impdp- Steve Harville
- » Re: how to improve impdp- Charles Schultz
- » RE: how to improve impdp- Patterson, Joel
- » RE: how to improve impdp- Iotzov, Iordan
- » Re: how to improve impdp- rjamya
- » RE: how to improve impdp- Hsieh, Joan
- » RE: how to improve impdp- David Kurtz
- » Re: how to improve impdp- Kamran Agayev (ICT/SNO)
- » RE: how to improve impdp- Patterson, Joel
- » Re: how to improve impdp- Bobby Curtis
- » RE: how to improve impdp- Hsieh, Joan
- » RE: how to improve impdp- Hsieh, Joan
- » Re: how to improve impdp- Bobby Curtis
- » Re: how to improve impdp- rjamya
- » RE: how to improve impdp- Michael McMullen
- » RE: how to improve impdp- Allen, Brandon
- » RE: how to improve impdp- Hsieh, Joan
- » Re: how to improve impdp- Nuno Souto
- » RE: how to improve impdp- Hsieh, Joan
- » Re: how to improve impdp- David Fitzjarrell
- » RE: how to improve impdp- Allen, Brandon
- » Re: how to improve impdp - Norman Dunbar
- » RE: how to improve impdp- Hsieh, Joan
- » Re: how to improve impdp- Norman Dunbar
- » RE: how to improve impdp- Patterson, Joel