Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    6

    Unanswered: ora-00942 table or view does not exist

    i tried the following in SQL*PLUS oracle9i

    SELECT * FROM jobs;
    SELECT * FROM empoyees;

    but got that error loging in as scott/tiger.
    Not sure if this is relevant but during installation of 9i on winXP, i changed password of system/manager to system/password. I read a study guide from Sybex which stated i needed to unlock the seed database with:

    ALTER USER HR IDENTIFIED HRPASSWORD ACCOUNT UNLOCK;

    I issues that statement logged in as system/password (i cannot connect as system/manager) it executed the statement as far as i know, however i still cannot run the SELECT statments above.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    login as scott/tiger & try select table_name from user_tables;

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Problem is not clear ...
    Do u have a problem with the user Scott or System or both..

    Please do check whether the specified tables are present or not...
    Did u say u cannot login as system.
    Changing Password of system will not cause hindrance to access the DB.

    Suggestion for not being able to select the tables could be.

    1. Scott is not the owner of those tables neither it has select privileges on them.
    Find out whether the tables are valid ones and their owners.
    Then grant select on Owner.jobs to Scott;
    Log in as scott and issue the following
    Select * from Owner.Jobs;

    2. The datafiles/tablespaces which consists those tables are offline.
    Find out using DBA_DATA_FILES,DBA_SEGMENTS,DBA_TABLESPACES.
    If the tablespace is offline bring it online.
    Alter tablespace <name> online;

    For not being able to loginto sqlplus as system could be because:

    1.System user has been locked:
    Log in as Sys and issue the following which u might have tried:
    Alter user System account unlock;
    IT WILL SAY USER ALTERED
    TRY TO LOG IN AS SYSTEM.
    2. Check from DBA_USERS whether system user is present or not.
    Possibly somebody could have dropped it..

    Do post the error u r receiving while log in as System.

    Hope it helps..
    KAushik

  4. #4
    Join Date
    Feb 2004
    Posts
    6
    yiha, figured it out....!*&(

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •