"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:MmYC9.80876$g9.227949_at_newsfeeds.bigpond.com...
>
> "Terry Mu" <terry_mu_at_yahoo.com> wrote in message
> news:_4XC9.118743$YSz1.53883_at_news01.bloor.is.net.cable.rogers.com...
> > I just installed Oracle 8.1.7 on Solaris 8. It says the installation is
> > successfull. When I check the demo database, I can't find Scott. What
> > happened?
> >
> > Can I reinstall the demo database without reinstalling the whole 8i?
> >
>
>
> No need. There are a couple of scripts you can run to put Scott in the
> database (who is being phased out -shame!- because he's too simple and his
> schema is not 'rich' enough to adequately demonstrate the wonderful new
> features in 8i and 9i).
>
> The one I always use is in $ORACLE_HOME/rdbms/admin and it's called
> utlsampl.sql. Run that in SQL*Plus, and it disconnects you... but a
'connect
> scott/tiger' then works.
>
> One thing to watch: the script always creates Scott without a default
> tablespace, and everything therefore ends up in the SYSTEM tablespace...
so
> I always edit the script first and stick an 'alter user scott default
> tablespace USERS;' towards the top of it.
>
> Alternatively, create your own user Scott, and set his default tablespace
as
> you'd like. Also grant appropriate privileges to him (again, look at
> utlsampl.sql to see what they should be) and then run the script
demobld.sql
> in the ORACLE_HOME/sqlplus/demo directory.
>
> Regards
> HJR
>
>
>
> > Thanks,
> >
> >
>
Poor old Tiger! Ignored and unloved, it seems.
Who will take in the stray cat?
Regards,
Manager (Change on Install)
Senior Oracle DBA
Received on Thu Nov 21 2002 - 16:40:12 CST
