dba_tablespaces does not exist [message #537766] |
Sat, 31 December 2011 00:26 |
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
|
|
|
|
|