OraFAQ Forum: Server Administration » data dictionary views

Home » RDBMS Server » Server Administration » data dictionary views

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

data dictionary views [message #417141]

Thu, 06 August 2009 04:55

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

Report message to a moderator

Re: data dictionary views [message #417149 is a reply to message #417141]

Thu, 06 August 2009 05:07

Littlefoot
Messages: 21813
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.

Report message to a moderator

Re: data dictionary views [message #417153 is a reply to message #417149]

Thu, 06 August 2009 05:24

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.

Report message to a moderator

Re: data dictionary views [message #417161 is a reply to message #417153]

Thu, 06 August 2009 05:55

ThomasG
Messages: 3211
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

Report message to a moderator

Previous Topic:	Permission issues while using sql trace (merged)
Next Topic:	Memory resizing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 04:15:48 CDT 2024