Re: acccessing the sample database on oracle 10g

My apologies I asked those questions in quick succession while downloading the documentation, problem solved now

cheers

"David Fitzjarrell" <fitzjarrell_at_cox.net> wrote in message news:9711ade0.0408141340.22fef93c_at_posting.google.com...
> "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 Sun Aug 15 2004 - 13:06:56 CDT