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.
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.