How Can you find out how big an individual table is?

[Grah]

Hi Folks,

I have been asked to find out how big a table is? and what is the likely DBF file size would be if exported?

Any ideas experiences that could shed some light onto the problems?

Cheers and thank you

[jmodic]

The size of the table is easy:

SELECT bytes FROM user_segment WHERE segment_name = 'MY_TABLE';

AS for the second question - do you mean how large *DMP* file size will be if exported (ie using Oracle exp utility)? If so, then it is very hard to tell. It depends mostly on how packed with actual data that table realy is.

[stecal]

Also depends on what "big" means. Lot of rows with little amount of data, few rows with tons of data, something in between. "How much space is used?" and "How big is a table?" can be two different issues.