Home » SQL & PL/SQL » SQL & PL/SQL » Number of rows & size of tables of a tablespace
Number of rows & size of tables of a tablespace [message #265767] Fri, 07 September 2007 05:49 Go to next message
gunbol
Messages: 4
Registered: September 2007
Junior Member
Hello,

I am looking for a view allowing to retrieve the size and the number of rows of all the tables of a specific view: something like

select tablename,numberofrows,sizeofthetable from **ThaMagicTable** where tablespace like 'mytablespace'

If someone know which table/view I must use, it would be great !

Best regards,

Gunther THEVENIN
Re: Number of rows & size of tables of a tablespace [message #265768 is a reply to message #265767] Fri, 07 September 2007 05:51 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What have you got so far? You searched the board, right?

MHE
Re: Number of rows & size of tables of a tablespace [message #265772 is a reply to message #265767] Fri, 07 September 2007 06:03 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Use
ALL_TABLES and DBA_TABLESPACES data dictionary
Re: Number of rows & size of tables of a tablespace [message #265797 is a reply to message #265767] Fri, 07 September 2007 07:32 Go to previous messageGo to next message
gunbol
Messages: 4
Registered: September 2007
Junior Member
Thank you, I have found all I need in the ALL_TABLES view.

Thank you for the reply !
Re: Number of rows & size of tables of a tablespace [message #265799 is a reply to message #265797] Fri, 07 September 2007 07:36 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
gunbol wrote on Fri, 07 September 2007 14:32
Thank you, I have found all I need in the ALL_TABLES view.

Thank you for the reply !

Make sure you've analyzed your schema before you rely on the NUM_ROWS column Wink. You need up-to-date statistics.

MHE

[Updated on: Fri, 07 September 2007 07:36]

Report message to a moderator

Previous Topic: Query Hangs
Next Topic: How to get login and hostname from the invoker of a procedure
Goto Forum:
  


Current Time: Sun Dec 04 12:44:46 CST 2016

Total time taken to generate the page: 0.16936 seconds