Home » SQL & PL/SQL » SQL & PL/SQL » to find out largest table in particular user
to find out largest table in particular user [message #277671] Wed, 31 October 2007 02:17 Go to next message
v.ram81
Messages: 50
Registered: April 2006
Location: pune
Member

hi ,
i want to find out largest table (in terms of number of rows)
in particular user.
How can i do that ?
i am working on

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE    9.2.0.1.0       Production
TNS for Linux: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
Re: to find out largest table in particular user [message #277672 is a reply to message #277671] Wed, 31 October 2007 02:19 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Analyze your schema (to get your statistics up to date) and have a look at the NUM_ROWS column in USER_TABLES.

MHE
Re: to find out largest table in particular user [message #277677 is a reply to message #277672] Wed, 31 October 2007 02:27 Go to previous message
v.ram81
Messages: 50
Registered: April 2006
Location: pune
Member

thanks a lot for quick answer.
i got it .
thank you.
Previous Topic: code to FTP the spool file from Sqlplus to the unix server.
Next Topic: How to update a table based on other table field value?
Goto Forum:
  


Current Time: Sun Dec 11 00:09:01 CST 2016

Total time taken to generate the page: 0.10943 seconds