OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » LOB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LOB [message #631243]

Sun, 11 January 2015 09:09

manishdba007
Messages: 27
Registered: September 2014
Location: India

Junior Member

Hello , during an activity i have done this -

SYS@***** AS SYSDBA > alter system set current_schema=*****;

SYS@***** AS SYSDBA >update imagenesinmuebles set imagen=null;

SYS@***** AS SYSDBA >commit;

SYS@***** AS SYSDBA >exit

3. Verification

Verify all columns of IMAGEN turn to null..
*********************************************

How do we now release space once the lob values have been updated to null?

Report message to a moderator

Re: LOB [message #631244 is a reply to message #631243]

Sun, 11 January 2015 09:11

manishdba007
Messages: 27
Registered: September 2014
Location: India

Junior Member

appreciate a quick response ..

Report message to a moderator

Re: LOB [message #631247 is a reply to message #631244]

Sun, 11 January 2015 09:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>appreciate a quick response ..

We appreciate you following Posting Guidelines that includes using GOOGLE

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

>How do we now release space once the lob values have been updated to null?
post SQL & results that show space has NOT been released already.
spaces released from where to where?
The same amount of disk space remains constant regardless what actions occur within any Oracle datatabase.

Report message to a moderator

Re: LOB [message #631249 is a reply to message #631243]

Sun, 11 January 2015 12:15

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

i have done this -

Which is VERY bad.
Read SYS is special.

Report message to a moderator

Previous Topic:	How to count working day
Next Topic:	convert comma separated string to IN clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 00:38:55 CDT 2024