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

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?
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: 10694
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.
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.
also look for demobld.sql which is a similiar script.
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

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

Current Time: Sun Dec 05 00:03:43 CST 2021