OraFAQ Forum: Server Administration » Is there any way to find the size of a table in oracle

Home » RDBMS Server » Server Administration » Is there any way to find the size of a table in oracle

Thu, 17 February 2005 19:27

omprasad
Messages: 4
Registered: February 2005

Junior Member

I have a table which has a blob column.i just want to find the size of that table. For loading the Blob file I am using java jdbc oci connection.

Tue, 22 February 2005 03:26

Sreedhar Reddy
Messages: 55
Registered: January 2002

Member

select segment_name,sum(bytes) from dba_segments
where segment_name='TABLE' AND OWNER='OWNER'
group by segment_name

Fri, 25 February 2005 20:48

omprasad
Messages: 4
Registered: February 2005

Junior Member

thanks for the sql query......

Fri, 22 July 2005 14:58

job_id
Messages: 3
Registered: March 2005

Junior Member

The blob is probably stored in a different segment than the 'table' segment.So you may not get the correct size of that table using the above query

[Updated on: Fri, 22 July 2005 14:58]

Previous Topic:	Deadlock situation Oracle 9i
Next Topic:	how could i make online db

Goto Forum:

]

Current Time: Sun Jan 26 09:24:46 CST 2025