Home » RDBMS Server » Server Administration » How to look for free tablespace..
How to look for free tablespace.. [message #50102] Thu, 28 February 2002 10:16 Go to next message
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.
Re: How to look for free tablespace.. [message #50108 is a reply to message #50102] Fri, 01 March 2002 02:35 Go to previous messageGo to next message
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
Re: How to look for free tablespace.. [message #50112 is a reply to message #50108] Fri, 01 March 2002 05:06 Go to previous message
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?)
Previous Topic: controlfile
Next Topic: Oracle 9i AS Problem
Goto Forum:
  


Current Time: Tue Dec 24 20:06:09 CST 2024