Home » RDBMS Server » Server Administration » select largest tables with variables
select largest tables with variables [message #374338] Wed, 06 June 2001 11:13 Go to next message
Michael Ngong
Messages: 4
Registered: June 2001
Junior Member
Can anyone get me a suitable statement to get the ten largest tables in my prd99 database which has more than a thousand tables and the corresponding pctincrease, pctfree, next, initial,owner and table_name
Un million de gracias
Mint
Re: select largest tables with variables [message #374353 is a reply to message #374338] Thu, 07 June 2001 08:42 Go to previous message
Lars Sjöström
Messages: 24
Registered: June 2001
Junior Member
I think you can use the view USER_SEGMENTS or SYSTEM_TABLES. There could be something similar to that a DBA has access to, where USER_NAME is a column.
Previous Topic: truncate and delete
Next Topic: getting there
Goto Forum:
  


Current Time: Mon Dec 23 12:54:32 CST 2024