Home » SQL & PL/SQL » SQL & PL/SQL » size of objects
size of objects [message #339069] Wed, 06 August 2008 12:40 Go to next message
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 Go to previous messageGo to next message
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

Re: size of objects [message #339118 is a reply to message #339092] Wed, 06 August 2008 16:32 Go to previous message
shoaib123
Messages: 118
Registered: December 2007
Location: Chicago
Senior Member
Thanks and appreciate your time
Previous Topic: concatinating date
Next Topic: suppressing results(or overriding results)
Goto Forum:
  


Current Time: Fri Feb 14 19:18:10 CST 2025