Home » SQL & PL/SQL » SQL & PL/SQL » how can i determine the size of a table?
how can i determine the size of a table? [message #245980] Tue, 19 June 2007 08:35 Go to next message
oracleram
Messages: 23
Registered: November 2006
Junior Member
hi,

how can i determine the size of a table?thanx in advance...
Re: how can i determine the size of a table? [message #245982 is a reply to message #245980] Tue, 19 June 2007 08:40 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
select sum(bytes)
from dba_extents
where segement_name='YOUR_TABLE_NAME'
Previous Topic: Help With Report Format
Next Topic: Sending e-mail from PL/SQL with attachment files
Goto Forum:
  


Current Time: Sun Dec 04 08:54:46 CST 2016

Total time taken to generate the page: 0.04317 seconds