Re: user and password for oracle sample db

Hi Louise,

You can :

SELECT TABLE_NAME FROM USER_TABLES; to see the tables you own (this will be different depending on which user you connect as.....try scott/tiger first)

Then, in SQL*Plus you can :

DESC EMP ( substitute any table name in place of EMP - I just chose it as an example because you should have it)

That will show you the columns..

Then you select the columns you want (for example, here's how to select ENAME, EMPNO and SAL) :

SELECT ENAME, EMPNO, SAL
FROM EMP; (notice the semicolon at the end - make sure you include that)

That will show you the data.....

I hope this helps,

Steve

"Gina" <louise_mc_dowell_at_hotmail.com-NOSPAM> wrote in message news:3b7a458d_3_at_mk-nntp-1.news.uk.worldonline.com...
> Thanks Sparks ... I am so glad about your posting !!! :)))
>
> I do have admin rights now .... and how can I view the tables, columns and
> data that is in that startup db ??
>
> I can only open/see the LOcal Roles .. I have opened it with
 SYSTEM/MANAGER
>
> On the win2000 OS I have admin rights
>
> THX Louise
>
> "Spark" <nospam_at_hotmail.com> wrote in message
> news:3b7a3867$0$8509$ed9e5944_at_reading.news.pipex.net...
> >
> > > I have installed oracle 8i and i cannot open the sample db .... what
 user
> > > and password is required ( I work on win2000)
> > >
> > > I know from previous versions I know there was a apart. user and
 password
> > > for that sample one.
> > >
> > > it's very urgent !!! I cannot start up anything without it ...
> > >
> > Try SCOTT/TIGER
> > SYSTEM/MANAGER
> > SYS/CHANGE_ON_INSTALL
> >
> > Regards,
> > Mark F
> >
> >
>
>
Received on Wed Aug 15 2001 - 08:02:54 CDT