Home » RDBMS Server » Server Administration » dba_tablespaces does not exist (10.2.0.1)
dba_tablespaces does not exist [message #537766] Sat, 31 December 2011 00:26 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
DBA_TABLESPACES does not exist,why?

SQL> show user;
USER is "SYS"
SQL> select table_name from dict where table_name like '%DBA_TABLE%';

TABLE_NAME
------------------------------
DBA_TABLES
DBA_TABLESPACES
DBA_TABLESPACE_GROUPS
DBA_TABLESPACE_USAGE_METRICS

SQL> select * from DBA_TABLESPACES;
select * from DBA_TABLESPACES
              *
ERROR at line 1:
ORA-00942: table or view does not exist



SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Re: dba_tablespaces does not exist [message #537773 is a reply to message #537766] Sat, 31 December 2011 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select owner, object_name, subobject_name, object_type
from dba_objects
where object_name='DBA_TABLESPACES'
/

Regards
Michel
Re: dba_tablespaces does not exist [message #537778 is a reply to message #537773] Sat, 31 December 2011 01:10 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks Michel,
The issue have solved by restart my db,i don't know why.
Previous Topic: Database Refresh (from demo to test)
Next Topic: how to drop a datafile
Goto Forum:
  


Current Time: Thu Apr 18 10:33:34 CDT 2024