当然首先要装好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
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!