Re: user and password for oracle sample db

Hi Stephen.

Thanks for your answer in the news ....

I had to re-install the Oracle amonst other things and now when trying to log onto the the sample db ( I can remember that there was some data and tables in the earlier versions!!)

well there are NO tables at all!!

it provides me with a new screen and wants to have a 'Net Service Name'

I actually do not have a clue as to what should go in there

I can as well rember that I found it quite strange that there is NO hint re these passwords!! Or should I have missed it .... already in version 7 ??

my email is louise_mc_dowell_at_hotmail.com

THX Louise

"Stephen Bell" <stephen.bell_at_cgi.ca> wrote in message news:foue7.21532$KG2.2361952_at_news20.bellglobal.com...
> 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 - 14:38:18 CDT