Home » RDBMS Server » Server Administration » data dictionary views
data dictionary views [message #417141] Thu, 06 August 2009 04:55 Go to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
I have a new installation of full database on my PC.Can anyone tell me how to install data dictionary views(or is it they are installed and I need something).
SQL> select * from v$version
  2  /

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 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

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

Re: data dictionary views [message #417149 is a reply to message #417141] Thu, 06 August 2009 05:07 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Data dictionary is installed automatically; you don't install it separately.

As of you being unable to query v$waitstat, well, you have probably connected to the database as a user who doesn't have required privileges. I guess that, if you connect as SYS, everything should work. Though, you should probably NOT abuse use of the SYS account - create another privileged user and grant it privileges you need. Leave SYS alone.
Re: data dictionary views [message #417153 is a reply to message #417149] Thu, 06 August 2009 05:24 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
thanks for your helpful reply.
yes I did not have the access rights.The data dictionary views are already there.
Re: data dictionary views [message #417161 is a reply to message #417153] Thu, 06 August 2009 05:55 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Of course, when you create the database not with the Database Configuration Assistant but "by hand" with a CREATE DATABASE statement, then you also have to run the creation of the data dictionary "by hand"

Creating the Data Dictionary
Previous Topic: Permission issues while using sql trace (merged)
Next Topic: Memory resizing
Goto Forum:
  


Current Time: Fri Dec 09 00:18:14 CST 2016

Total time taken to generate the page: 0.05988 seconds