How to find the size of a database table

Seems there are lots of ways of doing this, but this worked for me (on an Oracle DB). It returns the size of the database table in megabytes:

[code lang="sql"]
select bytes/1024/1024 from user_segments where segment_name='
'
[/code]

Leave a Reply