1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Ora-00942: table or view does not exist

Discussion in 'General' started by alexcol, Aug 19, 2017.

  1. alexcol

    alexcol Active Member

    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Colombia
    Good morning, i need your help please

    In order to see what sessions are active in a database server, i run the below query but it yields error:
    ORA-00942: table or view does not exist

    Code (SQL):
    SELECT SID, Serial#, UserName, STATUS, SchemaName, Logon_Time
    FROM V$Session
    WHERE
    STATUS='ACTIVE' AND
    UserName IS NOT NULL
    ORDER BY 6;
    FROM V$Session
     
    dont know if has something to do with privileges or permissions to query to system views?
    in other database server with a spscific user let me run that query
    if so is there any way or query to to see what sessions are active in a database server ?

    I appreciate your help in advanced
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,619
    Likes Received:
    364
    Trophy Points:
    1,430
    Location:
    Aurora, CO
  3. alexcol

    alexcol Active Member

    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Colombia