Home » Infrastructure » Windows » troubles with database
troubles with database [message #99837] Mon, 22 April 2002 08:04 Go to next message
Mieke
Messages: 1
Registered: April 2002
Junior Member
Hi,

I've installed Oracle Personal Edition 8.1.7. I've got a PIV, so I've first replaced SYMCJIT.DLL with symcjit.dll.ori and then the installation went fine.
But when I tried write and execute some simple commands in sql*plus
i.e. : SELECT *
FROM emp;
I got the message : "Table of view not known"

What can I do to solve this problem?

Report message to a moderator

Re: troubles with database [message #99838 is a reply to message #99837] Mon, 22 April 2002 10:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did you login as scott/tiger?
emp is the table that is create by default under scott schema.
in this case, table emp may not be created.
give
select sysdate from dual;
login as system/manager and give
select * from v$database;
if these queries are returning some values, then the db is installed properly.
look for the $oracle_homerdbmsadminscott.sql.
this file sql script creates all the demo tables(emp,dept etc) for scott user.
else
also look for demobld.sql which is a similiar script.

Report message to a moderator

Re: troubles with database [message #99925 is a reply to message #99837] Mon, 20 May 2002 19:44 Go to previous message
Michael Sale
Messages: 5
Registered: May 2002
Junior Member
while in sqlplus type in the following command:
show user

This will tell you who you are logged in as. Unless you are logged in as SCOTT, you will not be able to access the table in a SQL statement without qualifying it with the schema name(SCOTT in this case).

It is also possible that your database does NOT have the scott schema. To create it you

Report message to a moderator

Previous Topic: oracle9i
Next Topic: Windows 2000 and Printing
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 09:15:02 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.