OraFAQ Forum: Server Administration » How to look for free tablespace..

Home » RDBMS Server » Server Administration » How to look for free tablespace..

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to look for free tablespace.. [message #50102]

Thu, 28 February 2002 10:16

Vidya dambala
Messages: 1
Registered: February 2002

Junior Member

Oracle version is 7.1.6. I need to know how to check free tablespace on the database. I know that this query works:
select tablespace_name, sum(bytes)/1024/1024 from dba_free_space group by tablespace_name.
This does not work on my db.

The error is
ORA-00942: table or view does not exist.
Note: I have logged in as system too.

Report message to a moderator

Re: How to look for free tablespace.. [message #50108 is a reply to message #50102]

Fri, 01 March 2002 02:35

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

perhaps synonym has not been create for dba_free_space.

connect as sys user and try

Report message to a moderator

Re: How to look for free tablespace.. [message #50112 is a reply to message #50108]

Fri, 01 March 2002 05:06

saleem
Messages: 65
Registered: January 2002

Member

if you are getting this error then you most likely are not logged in as sys, system, or another user granted privileges to the table (as in does this user have dba role assignments?)

Report message to a moderator

Previous Topic:	controlfile
Next Topic:	Oracle 9i AS Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 02 22:50:25 CDT 2025