DESC USER_SEGMENTS


-----Original Message-----
From: Sarvanan
[mailto:oracledba-ezmlmshield-x21168117.[Email address protected]
Sent: Wednesday, March 01, 2006 6:06 AM
To: LazyDBA Discussion
Subject: total no of blocks for 1 lakh records


Hi

My master table contains 1 lakh records.

I need a query to find the total no of blocks occupied by the
records(i,e for that table).

Can any one help in the same?



Tnks in advance





Regards,

Saravanan V M

I-Flex Park

Bangalore.







DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]

Oracle LazyDBA home page