Home » RDBMS Server » Server Administration » Table missings
Table missings [message #53984] Wed, 23 October 2002 01:15 Go to next message
Mohini
Messages: 3
Registered: October 2002
Junior Member
I tried to query the V$sqlarea table but its giving me error saying table/view doesn't exists. Wopuld anyone let em know which script file has to be ruun in oprder to create it.

Thanks

Report message to a moderator

Re: Table missings [message #53987 is a reply to message #53984] Wed, 23 October 2002 01:58 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
no v$sqlarea exists .. or Ur database is damage ...
( did U run catalog ??? )

try sys.v$sqlarea...

May be U don't have right to query it....

Report message to a moderator

Re: Table missings [message #53994 is a reply to message #53984] Wed, 23 October 2002 04:55 Go to previous messageGo to next message
puneet
Messages: 76
Registered: August 2002
Member
login as sys or system u will get it .. probably the user u r logging in does not have the required privilages...

Report message to a moderator

please read replies before post the same reply ! [message #54003 is a reply to message #53984] Wed, 23 October 2002 06:39 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
lol

Report message to a moderator

Previous Topic: Connecting Oracle
Next Topic: Oracle Technical Information Required
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:13:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.