Saturn is not one I've heard of before, but the reason Adams, Blake etc are
not there when you load the sample schemas is because we created new sample
schemas in 9i. One of the reasons for this is so we can use a consistent
set of examples in our documentation and training. Another is because it's
damn hard to show the benefits of some of the functionality of the database
using the old demo accounts. Ever thought of how difficult it is to show
partition pruning using EMP and DEPT? ;)
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Van Messner" <vmessner_at_bestweb.net> wrote in message
news:u3k9h2lvrn2254_at_corp.supernews.com...
> This is interesting. I never do typical installs so these are new to me.
I
> did install the samples in 9i but didn't get these users. I took a look
at
> the 9i sql.bsq which is the only one I have here and there is no reference
> to utlsampl.sql, so I wonder where it's called from?
>
> utlsampl.sql is below - so what about Saturn?
>
> Rem Copyright (c) 1990, 1996, 1997, 1999, 2001 by Oracle Corporation
> Rem NAME
> REM UTLSAMPL.SQL
> Rem FUNCTION
> Rem NOTES
> Rem MODIFIED
> Rem menash 02/21/01 - remove unnecessary users for security
reasons
> Rem gwood 03/23/99 - make all dates Y2K compliant
> Rem jbellemo 02/27/97 - dont connect as system
> Rem akolk 08/06/96 - bug 368261: Adding date formats
> Rem glumpkin 10/21/92 - Renamed from SQLBLD.SQL
> Rem blinden 07/27/92 - Added primary and foreign keys to EMP and
DEPT
> Rem rlim 04/29/91 - change char to varchar2
> Rem mmoore 04/08/91 - use unlimited tablespace priv
> Rem pritto 04/04/91 - change SYSDATE to 13-JUL-87
> Rem Mendels 12/07/90 - bug 30123;add to_date calls so language
> independent
> Rem
> rem
> rem $Header: utlsampl.sql 21-feb-01.18:15:30 menash Exp $ sqlbld.sql
> rem
> SET TERMOUT OFF
> SET ECHO OFF
>
> rem CONGDON Invoked in RDBMS at build time. 29-DEC-1988
> rem OATES: Created: 16-Feb-83
>
> DROP USER SCOTT CASCADE;
> DROP USER ADAMS CASCADE;
> DROP USER JONES CASCADE;
> DROP USER CLARK CASCADE;
> DROP USER BLAKE CASCADE;
> GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER;
> DROP PUBLIC SYNONYM PARTS;
>
> CONNECT SCOTT/TIGER
> CREATE TABLE DEPT
> (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,
> DNAME VARCHAR2(14) ,
> LOC VARCHAR2(13) ) ;
> CREATE TABLE EMP
> (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,
> ENAME VARCHAR2(10),
> JOB VARCHAR2(9),
> MGR NUMBER(4),
> HIREDATE DATE,
> SAL NUMBER(7,2),
> COMM NUMBER(7,2),
> DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);
> INSERT INTO DEPT VALUES
> (10,'ACCOUNTING','NEW YORK');
> INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');
> INSERT INTO DEPT VALUES
> (30,'SALES','CHICAGO');
> INSERT INTO DEPT VALUES
> (40,'OPERATIONS','BOSTON');
> INSERT INTO EMP VALUES
>
(7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20);
> INSERT INTO EMP VALUES
>
(7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30)
> ;
> INSERT INTO EMP VALUES
>
(7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30);
> INSERT INTO EMP VALUES
>
(7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20);
> INSERT INTO EMP VALUES
>
(7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,3
> 0);
> INSERT INTO EMP VALUES
>
(7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30);
> INSERT INTO EMP VALUES
>
(7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10);
> INSERT INTO EMP VALUES
>
(7788,'SCOTT','ANALYST',7566,to_date('13-JUL-87','dd-mm-rr')-85,3000,NULL,20
> );
> INSERT INTO EMP VALUES
>
(7839,'KING','PRESIDENT',NULL,to_date('17-11-1981','dd-mm-yyyy'),5000,NULL,1
> 0);
> INSERT INTO EMP VALUES
>
(7844,'TURNER','SALESMAN',7698,to_date('8-9-1981','dd-mm-yyyy'),1500,0,30);
> INSERT INTO EMP VALUES
> (7876,'ADAMS','CLERK',7788,to_date('13-JUL-87',
> 'dd-mm-rr')-51,1100,NULL,20);
> INSERT INTO EMP VALUES
> (7900,'JAMES','CLERK',7698,to_date('3-12-1981','dd-mm-yyyy'),950,NULL,30);
> INSERT INTO EMP VALUES
>
(7902,'FORD','ANALYST',7566,to_date('3-12-1981','dd-mm-yyyy'),3000,NULL,20);
> INSERT INTO EMP VALUES
>
(7934,'MILLER','CLERK',7782,to_date('23-1-1982','dd-mm-yyyy'),1300,NULL,10);
> CREATE TABLE BONUS
> (
> ENAME VARCHAR2(10) ,
> JOB VARCHAR2(9) ,
> SAL NUMBER,
> COMM NUMBER
> ) ;
> CREATE TABLE SALGRADE
> ( GRADE NUMBER,
> LOSAL NUMBER,
> HISAL NUMBER );
> INSERT INTO SALGRADE VALUES (1,700,1200);
> INSERT INTO SALGRADE VALUES (2,1201,1400);
> INSERT INTO SALGRADE VALUES (3,1401,2000);
> INSERT INTO SALGRADE VALUES (4,2001,3000);
> INSERT INTO SALGRADE VALUES (5,3001,9999);
> COMMIT;
> EXIT
>
>
>
>
>
> "Ray Teale" <ray_at_BLAHholly.com.au> wrote in message
> news:iip_7.3033$lt4.144513_at_ozemail.com.au...
> >
> > "Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message
> > news:3C378C3B.34ADD0BD_at_exesolutions.com...
> > > NEver seen all ADAMS, BLAKE, CLARK, and SATURN after many 8i installs.
I
> > suspect
> > > you have something/someone else meddling about. The others are used by
> > options
> > > you, or someone else, installed.
> > >
> >
> > ADAMS, BLAKE, CLARK and JONES, are created during install by the
> > utlsampl.sql in the rdbms/admin directory, as part of the demo stuff.
All
> > my "typical" installs have them. I just drop them as they seem to be of
> no
> > use. I have no idea which part of the install creates them.
> >
> > Regards
> >
> > Ray
> >
> > > Dan Morgan
> > >
> > >
> > >
> > > Zoran Marjanski wrote:
> > >
> > > > This may seem like a silly question but my curiosity has gotten the
> best
> > of
> > > > me.
> > > >
> > > > In 8i there are a bunch of extra Oracle Users created during
> > installation. I
> > > > know about SCOTT, the sample schema, but who are the rest and what
are
> > > > they're passwords? Are they just other sample SCOTT's, but they
don't
> > have
> > > > any database objects with them.
> > > >
> > > > What about the rest of them? Are these documented somewhere?
> > > >
> > > > ADAMS ?
> > > > AURORA$JIS$UTILITY$ Java?
> > > > AURORA$ORB$UNAUTHENTICATED Java?
> > > > BLAKE ?
> > > > CLARK ?
> > > > CTXSYS ?
> > > > DBSNMP Used for SNMP?
> > > > DES6I Used by Designer 6i
> > > > JONES ?
> > > > MDSYS ?
> > > > MTSSYS ?
> > > > ORDPLUGINS ?
> > > > ORDSYS ?
> > > > OSE$HTTP$ADMIN Something to do with administration via http?
> > > > OUTLN ?
> > > > SATURN Used by OEM
> > > > SCOTT I know about this one
> > > > SYS I know about this one
> > > > SYSTEM I know about this one
> > > >
> > > > Thanks, Zoran.
> > >
> >
> >
>
>
Received on Tue Jan 08 2002 - 09:50:17 CST
