Re: Accessing the seed database

From: John T. Fansler <j.fansler_at_attbi.com>
Date: Wed, 08 Jan 2003 03:22:50 GMT
Message-ID: <eQMS9.483896$GR5.191282_at_rwcrnsc51.ops.asp.att.net>

Look for the following file 'UTLSAMPL.SQL' It is the file that creats your seed tables.

Some of the lines from the file include the following:

GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER; GRANT CONNECT TO ADAMS IDENTIFIED BY WOOD;

GRANT CONNECT TO JONES IDENTIFIED BY STEEL;
GRANT CONNECT TO CLARK IDENTIFIED BY CLOTH;
GRANT CONNECT TO BLAKE IDENTIFIED BY PAPER;
CREATE TABLE DEPT ...

CREATE TABLE EMP ...
CREATE TABLE BONUS ...
CREATE TABLE SALGRADE ... This should be enough to get you started.

Have fun.

• Original Message ----- From: "Ken Endeley" <kenendeley_at_lycos.com> Newsgroups: comp.databases.oracle.tools Sent: Tuesday, January 07, 2003 6:29 AM Subject: Re: Accessing the seed database

> Oracle 9.i Release 2(9.2.0.1.0)
> Win2k Professional
>
> I login to SQL*plus with username:scott Password:tiger
>
> then at the prompt I type
>
> select * from jobs;
>
> I get an error message saying :
>
> Error at line 1:
> ORA-00942: table or view does not exist.
>
> I am not sure if the table is availabe or if I'm logged in with the
correct
> password. I understand what you mean by schema. I am a complete newbie
>
> Thanks
> Ken
> kenendeley_at_lycos.com
>
>> Oracle Newbie
>> "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
>> news:3E1A2519.854C896E_at_exesolutions.com...
> > Ken Endeley wrote:
>>
>> I have just finished installing Oracle 9i personal edition and I am
trying
>> to access the seed database but I can't. Specifically, I am trying to
access
>> the jobs and employees table.
>>
>> Can anyone help please?
>>
>> Thanks
>> Mfon
Received on Wed Jan 08 2003 - 04:22:50 CET