Re: scott/tiger missing after database creation

From: <tedchyn_at_yahoo.com>
Date: Thu, 03 Jun 1999 13:40:58 GMT
Message-ID: <7j60l8$flc$1@nnrp1.deja.com>

ed, there is separate script which create user scott and tables owned by him. look in admin directory to find the script.

Ted
In article <7j4kvu$2k8$1_at_nnrp1.deja.com>, ewong74_at_netscape.net wrote:
> I am running 8.05 on Solaris 2.6. I destroyed the 2k block size db
> instance and create a 8k one. After the new db is created, there is
no
> scott/tiger existing anymore. Only 3 default users exist: sys,
system,
> dbsnmp. I would like to get scott back. Anyone has idea? Am I
missing
> some scripts that I need to run?
>
> After I issue the 'create database' statement, I run these 2 scripts
as
> 'internal':
> @@$ORACLE_HOME/rdbms/admin/catalog.sql
> @@$ORACLE_HOME/rdbms/admin/catproc.sql
>
> Thanks.
>
> Ed
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 03 1999 - 08:40:58 CDT