添加scott用户与其对象
发现没有scott用户,rdbms/admin下也没有相应的创建脚本。<br><br>网上找了个脚本,经过试验证明可用。<br><br>脚本命名为scott.sql放到一下目录即可以:<br>/opt/oracle/product/10.2.0/rdbms/admin<br><br>脚本内容:<br><font color="#008080"><strong>Rem Copyright (c) 1990 by Oracle Corporation<br>Rem NAME<br>
REM UTLSAMPL.SQL<br>
Rem FUNCTION<br>
Rem NOTES<br>
Rem MODIFIED<br>
Rem gdudey 06/28/95 - Modified for desktop seed database<br>
Rem glumpkin 10/21/92 - Renamed from SQLBLD.SQL<br>
Rem blinden 07/27/92 - Added primary and foreign keys to EMP and DEPT<br>
Rem rlim 04/29/91 - change char to varchar2<br>
Rem mmoore 04/08/91 - use unlimited tablespace priv<br>
Rem pritto 04/04/91 - change SYSDATE to 13-JUL-87<br>
Rem Mendels 12/07/90 - bug 30123;add to_date calls so language independent<br>
Rem<br>
rem<br>
rem $Header: utlsampl.sql 7020100.1 94/09/23 22:14:24 cli Generic<base>; $ sqlbld.sql<br>
rem<br>
SET TERMOUT OFF<br>
SET ECHO OFF<br>
<br>
rem CONGDON Invoked in RDBMS at build time. 29-DEC-1988<br>
rem OATES: Created: 16-Feb-83<br>
<br>
GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY TIGER;<br>
ALTER USER SCOTT DEFAULT TABLESPACE USERS;<br>
ALTER USER SCOTT TEMPORARY TABLESPACE TEMP;<br>
CONNECT SCOTT/TIGER<br>
DROP TABLE DEPT;<br>
CREATE TABLE DEPT<br>
(DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,<br>
DNAME VARCHAR2(14) ,<br>
LOC VARCHAR2(13) ) ;<br>
DROP TABLE EMP;<br>
CREATE TABLE EMP<br>
(EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,<br>
ENAME VARCHAR2(10),<br>
JOB VARCHAR2(9),<br>
MGR NUMBER(4),<br>
HIREDATE DATE,<br>
SAL NUMBER(7,2),<br>
COMM NUMBER(7,2),<br>
DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);<br>
INSERT INTO DEPT VALUES<br>
(10,'ACCOUNTING','NEW YORK');<br>
INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');<br>
INSERT INTO DEPT VALUES<br>
(30,'SALES','CHICAGO');<br>
INSERT INTO DEPT VALUES<br>
(40,'OPERATIONS','BOSTON');<br>
INSERT INTO EMP VALUES<br>
(7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20);<br>
INSERT INTO EMP VALUES<br>
(7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30);<br>
INSERT INTO EMP VALUES<br>
(7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30);<br>
INSERT INTO EMP VALUES<br>
(7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20);<br>
INSERT INTO EMP VALUES<br>
(7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,30);<br>
INSERT INTO EMP VALUES<br>
(7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30);<br>
INSERT INTO EMP VALUES<br>
(7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10);<br>
INSERT INTO EMP VALUES<br>
(7788,'SCOTT','ANALYST',7566,to_date('13-JUL-87')-85,3000,NULL,20);<br>
INSERT INTO EMP VALUES<br>
(7839,'KING','PRESIDENT',NULL,to_date('17-11-1981','dd-mm-yyyy'),5000,NULL,10);<br>
INSERT INTO EMP VALUES<br>
(7844,'TURNER','SALESMAN',7698,to_date('8-9-1981','dd-mm-yyyy'),1500,0,30);<br>
INSERT INTO EMP VALUES<br>
(7876,'ADAMS','CLERK',7788,to_date('13-JUL-87')-51,1100,NULL,20);<br>
INSERT INTO EMP VALUES<br>
(7900,'JAMES','CLERK',7698,to_date('3-12-1981','dd-mm-yyyy'),950,NULL,30);<br>
INSERT INTO EMP VALUES<br>
(7902,'FORD','ANALYST',7566,to_date('3-12-1981','dd-mm-yyyy'),3000,NULL,20);<br>
INSERT INTO EMP VALUES<br>
(7934,'MILLER','CLERK',7782,to_date('23-1-1982','dd-mm-yyyy'),1300,NULL,10);<br>
DROP TABLE BONUS;<br>
CREATE TABLE BONUS<br>
(<br>
ENAME VARCHAR2(10) ,<br>
JOB VARCHAR2(9) ,<br>
SAL NUMBER,<br>
COMM NUMBER<br>
) ;<br>
DROP TABLE SALGRADE;<br>
CREATE TABLE SALGRADE<br>
( GRADE NUMBER,<br>
LOSAL NUMBER,<br>
HISAL NUMBER );<br>
INSERT INTO SALGRADE VALUES (1,700,1200);<br>
INSERT INTO SALGRADE VALUES (2,1201,1400);<br>
INSERT INTO SALGRADE VALUES (3,1401,2000);<br>
INSERT INTO SALGRADE VALUES (4,2001,3000);<br>
INSERT INTO SALGRADE VALUES (5,3001,9999);<br>
COMMIT;<br>
<br>
SET TERMOUT ON<br>
SET ECHO ON</strong></font><br><br>最后:<br>SQL>@/opt/oracle/product/10.2.0/rdbms/admin/scott.sql<br>即可。<br>
页:
[1]