Oracle express启用scott用户

一般安装Oracle之后，如果scott用户无法登录，则需要以system用户登录，然后解锁即可

SQL> ALTER user scott account UNLOCK
SQL> ALTER user scott IDENTIFIED BY tiger;修改scott用户密码

 

可是发现速成版中根本就没有scott用户，自然也就无法解锁，这应该是需要运行soctt.sql文件，从$ORACLE_HOME/rdbms/admin
文件夹中寻找，发现也并没有scott.sql文件。
这可能是由于express版本中本来就不带有该文件的缘故，可以从其他版本中复制，soctt.sql文件内容如下，可以复制，运行即可

Rem   Copyright   (c)   1990   BY   Oracle   Corporation
Rem   NAME
REM         UTLSAMPL.SQL
Rem     FUNCTION
Rem     NOTES
Rem     MODIFIED
Rem gdudey       06/28/95   -     Modified   FOR   desktop   seed   DATABASE
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   7020100.1   94/09/23   22:14:24   cli   Generic <base>   $   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
 
GRANT   CONNECT,RESOURCE,UNLIMITED   TABLESPACE   TO   SCOTT   IDENTIFIED   BY   TIGER;
ALTER   USER   SCOTT   DEFAULT   TABLESPACE   USERS;
ALTER   USER   SCOTT   TEMPORARY   TABLESPACE   TEMP;
CONNECT   SCOTT/TIGER
DROP   TABLE   DEPT;
CREATE   TABLE   DEPT
              (DEPTNO   NUMBER(2)   CONSTRAINT   PK_DEPT   PRIMARY   KEY,
DNAME   VARCHAR2(14)   ,
LOC   VARCHAR2(13)   )   ;
DROP   TABLE   EMP;
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,30);
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')-85,3000,NULL,20);
INSERT   INTO   EMP   VALUES
(7839, 'KING', 'PRESIDENT',NULL,to_date( '17-11-1981', 'dd-mm-yyyy'),5000,NULL,10);
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')-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);
DROP   TABLE   BONUS;
CREATE   TABLE   BONUS
(
ENAME   VARCHAR2(10) ,
JOB   VARCHAR2(9)     ,
SAL   NUMBER,
COMM   NUMBER
)   ;
DROP   TABLE   SALGRADE;
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;
 
SET   TERMOUT   ON
SET   ECHO   ON

 

 

OK，将该文件导入即可

[root@localhost human_resources]# sqlplus system
 
SQL*Plus: Release 10.2.0.1.0 - Production ON Fri Nov 5 11:17:29 2010
 
Copyright (c) 1982, 2005, Oracle.  ALL rights reserved.
 
Enter password:
 
Connected TO:
Oracle DATABASE 10g Express Edition Release 10.2.0.1.0 - Production
 
SQL> @/root/scott.sql
SQL> conn scott
Enter password:
Connected.

 

以scott用户登录，可以正常使用了。开始享受中^_^

评论

1 楼 lhl5230 2013-06-06  

谢谢，很有用。。。