Home » SQL & PL/SQL » SQL & PL/SQL » Table rows and sizes. (oracle 10g.)
Table rows and sizes. [message #285819] Wed, 05 December 2007 14:42 Go to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

hello,
how do i write a sql that can fetch me the tablename, size of the table and also the number of rows of that table ? (Assuming I dont have the stats analyzed for schema)

Thanks.
Re: Table rows and sizes. [message #285826 is a reply to message #285819] Wed, 05 December 2007 16:06 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
count,user_segments
Re: Table rows and sizes. [message #285830 is a reply to message #285826] Wed, 05 December 2007 16:31 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.orafaq.com/forum/t/82637/2/
Previous Topic: Is it possible to edit a procedure/function
Next Topic: Initialization of a bind variable
Goto Forum:
  


Current Time: Sun Dec 11 04:16:47 CST 2016

Total time taken to generate the page: 0.07638 seconds