Re: There isn't Scott after a successful installation

"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,
>
>
Received on Wed Nov 20 2002 - 21:34:33 CST