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   CorporationRem   NAMEREM         UTLSAMPL.SQLRem     FUNCTIONRem     NOTESRem     MODIFIEDRem gdudey       06/28/95   -     Modified   FOR   desktop   seed   DATABASERem glumpkin       10/21/92   -     Renamed   FROM   SQLBLD.SQLRem blinden       07/27/92   -     Added   PRIMARY   AND   FOREIGN   KEYS   TO   EMP   AND   DEPTRem rlim       04/29/91   -             CHANGE   char   TO   varchar2Rem mmoore       04/08/91   -             USE   unlimited   tablespace   privRem pritto       04/04/91   -             CHANGE   SYSDATE   TO   13-JUL-87Rem       Mendels   12/07/90   -   bug   30123;add   to_date   calls   so   LANGUAGE   independentRemremrem   $Header:   utlsampl.sql   7020100.1   94/09/23   22:14:24   cli   Generic <base>   $   sqlbld.sqlremSET   TERMOUT   OFFSET   ECHO   OFF rem   CONGDON         Invoked   IN   RDBMS   at   build   time.   29-DEC-1988rem   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/TIGERDROP   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   ONSET   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.sqlSQL> conn scottEnter password:Connected.

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