oracle账户解锁 plsql,PLsql/Oracle数据库中没有scott账户，如何创建并解锁

当然首先要装好oracle 11g

然后还要有sqlplus，这个在oracle11g的时候应该都会配上的

进入正题，如果oracle/plsql没scott账户，如何创建

先找到oracle安装目录下的soctt.sql

我的是在：

e:\app\91959\product\11.2.0\dbhome_1\admin

如果没有soctt.sql，先建立一个txt文件，复制下面的代码进去，然后改成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 $ 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

在sqlplus运行你刚创建的scott.sql，即上面那句

然后还需要为soctt用户解锁，要切换到sys管理员才能操作，执行红框的代码就解锁成功了，这样就大功告成了

文章摘录：https://blog.csdn.net/lingdian1614114082/article/details/85000640

如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！