size of objects [message #339069] |
Wed, 06 August 2008 12:40  |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
oracle Release 9.2.0.8.0, windows professional 2002
I need to check the space taken by the objects in the different schema. I don't have privileges to any of the dba tables. i tried dba_spegments.. Is there any all_ or user_ tables in database, i can look for those information..
|
|
|
Re: size of objects [message #339092 is a reply to message #339069] |
Wed, 06 August 2008 13:57   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
ALL_SEGMENTS, but that will only give you the details on table and indexes you have access to. Other objects do not take up space.
I'm afraid you need DBA rights or the password of the other schema to be able to do what you need.
[added] or of course, access to the all the tables and indexes in that schema, but I am guessing there would be at least one that you do not have access to.
[Updated on: Wed, 06 August 2008 13:58] Report message to a moderator
|
|
|
|