Home » RDBMS Server » Server Administration » Table Size
Table Size [message #341131] Sat, 16 August 2008 23:50 Go to next message
Messages: 6
Registered: August 2008
Junior Member
I wanna know the size of a table from
select sum(bytes) from dba_segments where segment_name='table_name'

but the result is confusing.... the output is like 500MB but the actual size is about 4GB when i took a dump of that table.
Re: Table Size [message #341132 is a reply to message #341131] Sat, 16 August 2008 23:52 Go to previous messageGo to next message
Messages: 25572
Registered: January 2009
Location: SoCal
Senior Member
Please read & FOLLOW the Posting Guidelines as stated in URL above
Re: Table Size [message #341134 is a reply to message #341131] Sat, 16 August 2008 23:57 Go to previous message
Messages: 133
Registered: June 2007
Senior Member
May be the table has a column of LOB type.
I got a solution here...
Previous Topic: ERROR ORA-01114
Next Topic: Oracle Workspace Manager
Goto Forum:

Current Time: Sun Aug 20 18:14:16 CDT 2017

Total time taken to generate the page: 0.01365 seconds