Re: acccessing the sample database on oracle 10g

"Nospam" <nospam_at_home.com> wrote in message news:<5OpTc.221$Uj1.59_at_newsfe4-gui.ntli.net>...
> I have installed oracle 10g on red hat linu 9. I am wondering what I type
> to access the sample dataase scott/tiger v$ession. what do I type after
>
> sysdba /nolog
>
> to access and manipulate the sample databases?
>
> thanks

• Original Message ----- From: "Nospam" <nospam_at_home.com> Newsgroups: comp.databases.oracle.server Sent: Saturday, August 14, 2004 3:11 PM Subject: Re: acccessing the sample database on oracle 10g

>
>
>
> Another quick question
>
>
> after
>
> connect a sysdba /nolog
>
> startup
>

How does this actually work? I am familiar with:

$ sqlplus /nolog

...

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup  

> and
>
> select * from employees it said table does not exit
>

The employee table is in the HR schema, which you may or may not have installed. It was never part of SCOTT's schema, and it certainly is not owned by SYS. And, of course, you are currently connected as SYS using connect / as sysdba.

> I have the SID in the tnsnames.ora and listener.ora files, what am I doing
> wrong?
>

Everything, apparently. I would read the documentation at tahiti.oracle.com and start learning Oracle. Asking for clarification on topics is one thing, asking for tutelage from this newsgroup is quite another. And, tutelage is NOT available here.

David Fitzjarrell Received on Sat Aug 14 2004 - 16:40:18 CDT