Oracle express启用scott用户

古城微笑少年丶 2021-06-24 14:34 427阅读 0赞

一般安装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用户登录，可以正常使用了。开始享受中^\_^