Home » RDBMS Server » Server Administration » Table Size having BLOB data type
Table Size having BLOB data type [message #278759] Mon, 05 November 2007 10:34 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
We have a table which has BLOB datatype. We do lots of delete and insert in this tables, There is a separate tablespace for this table. This has grown so big. I am pretty sure the table will not be that large. Following are my question

1. How do I check what is the exact size of this table?
2. If I move this table along with BLOB cloumn to a new created tablespace, how big do I need to create this new tablespace??
3. Is there any other method to reclaim space from the old tablespace?

Thanks in Advance.

Toshi
Re: Table Size having BLOB data type [message #278763 is a reply to message #278759] Mon, 05 November 2007 10:52 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
[varu123 answer was: select sum(bytes) from dba_segments where segment_name='your segment name']

[Updated on: Mon, 05 November 2007 12:21] by Moderator

Report message to a moderator

Re: Table Size having BLOB data type [message #278767 is a reply to message #278763] Mon, 05 November 2007 11:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
varu123, LOB are located in a separate segment so your query will not give the answer.

Regards
Michel
Re: Table Size having BLOB data type [message #278769 is a reply to message #278759] Mon, 05 November 2007 11:35 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Yes, LOB are stored outside the tablespace.
Re: Table Size having BLOB data type [message #278790 is a reply to message #278769] Mon, 05 November 2007 12:08 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
Please don't remove your old posts, no matter how incorrect they are. Now it looks as if Michel is schizophrenic.
Re: Table Size having BLOB data type [message #278797 is a reply to message #278759] Mon, 05 November 2007 12:34 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:

Now it looks as if Michel is schizophrenic.

Michel is a package of knowledge.Use it as much as you can Razz
Re: Table Size having BLOB data type [message #278857 is a reply to message #278759] Tue, 06 November 2007 00:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Check segment_type in dba_segments.
Re: Table Size having BLOB data type [message #279282 is a reply to message #278797] Wed, 07 November 2007 10:40 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Alter knowledge package recompile;)
Previous Topic: ASM Diskgroup dismounted - how to drop disk from?
Next Topic: Uninstalled Oracle
Goto Forum:
  


Current Time: Wed Dec 07 12:46:45 CST 2016

Total time taken to generate the page: 0.11412 seconds