oracle提供了scott用户的重建脚本，11g利用脚本创建scott简单操作如下：sqlgt; select * from dba_users where username=
oracle提供了scott用户的重建脚本，11g利用脚本创建scott简单操作如下：
sql> select * from dba_users where username='scott'; ------之前已手动删除scott
no rows selected
sql> exit
disconnected from oracle database 11g enterprise edition release 11.2.0.3.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
@pekdc1-vcm-03: [/usr/app/oracle/110203/v04/rdbms/admin]
$cd $oracle_home/rdbms/admin ------脚本位置
@pekdc1-vcm-03: [/usr/app/oracle/110203/v04/rdbms/admin]
$ls -lhrt utlsampl.sql
-rw-r--r-- 1 oracle oinstall 3.6k may 28 2013 utlsampl.sql
@pekdc1-vcm-03: [/usr/app/oracle/110203/v04/rdbms/admin]
$sqlplus / as sysdba
sql*plus: release 11.2.0.3.0 production on mon mar 24 10:15:29 2014
copyright (c) 1982, 2011, oracle. all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.3.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
sql> @utlsampl.sql ------运行脚本，完成后会自动退出sqlplus
disconnected from oracle database 11g enterprise edition release 11.2.0.3.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
@pekdc1-vcm-03: [/usr/app/oracle/110203/v04/rdbms/admin]
$sqlplus scott/tiger
sql*plus: release 11.2.0.3.0 production on mon mar 24 10:15:47 2014
copyright (c) 1982, 2011, oracle. all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.3.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
sql> show user
user is scott
sql> select table_name from user_tables;
table_name
------------------------------
dept
emp
bonus
salgrade
sql> select * from emp;
empno ename job mgr hiredate sal comm
---------- ---------- --------- ---------- --------- ---------- ----------
deptno
----------
7369 smith clerk 7902 17-dec-80 800
20
7499 allen salesman 7698 20-feb-81 1600 300
30
7521 ward salesman 7698 22-feb-81 1250 500
30
empno ename job mgr hiredate sal comm
---------- ---------- --------- ---------- --------- ---------- ----------
deptno
----------
7566 jones manager 7839 02-apr-81 2975
20
7654 martin salesman 7698 28-sep-81 1250 1400
30
7698 blake manager 7839 01-may-81 2850
30
empno ename job mgr hiredate sal comm
---------- ---------- --------- ---------- --------- ---------- ----------
deptno
----------
7782 clark manager 7839 09-jun-81 2450
10
7788 scott analyst 7566 19-apr-87 3000
20
7839 king president 17-nov-81 5000
10
empno ename job mgr hiredate sal comm
---------- ---------- --------- ---------- --------- ---------- ----------
deptno
----------
7844 turner salesman 7698 08-sep-81 1500 0
30
7876 adams clerk 7788 23-may-87 1100
20
7900 james clerk 7698 03-dec-81 950
30
empno ename job mgr hiredate sal comm
---------- ---------- --------- ---------- --------- ---------- ----------
deptno
----------
7902 ford analyst 7566 03-dec-81 3000
20
7934 miller clerk 7782 23-jan-82 1300
10
14 rows selected.
sql> exit
disconnected from oracle database 11g enterprise edition release 11.2.0.3.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
@pekdc1-vcm-03: [/usr/app/oracle/110203/v04/rdbms/admin]
$more utlsampl.sql ------脚本内容
rem copyright (c) 1990, 2006, oracle. all rights reserved.
rem name
rem utlsampl.sql
rem function
rem notes
rem modified
rem lburgess 04/02/06 - lowercase passwords
rem menash 02/21/01 - remove unnecessary users for security reasons
rem gwood 03/23/99 - make all dates y2k compliant
rem jbellemo 02/27/97 - dont connect as system
rem akolk 08/06/96 - bug 368261: adding date formats
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 02-apr-2006.21:13:01 lburgess exp $ 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
drop user scott cascade;
drop user adams cascade;
drop user jones cascade;
drop user clark cascade;
drop user blake cascade;
grant connect,resource,unlimited tablespace to scott identified by tiger;
drop public synonym parts;
connect scott/tiger
create table dept
(deptno number(2) constraint pk_dept primary key,
dname varchar2(14) ,
loc varchar2(13) ) ;
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','dd-mm-rr')-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', 'dd-mm-rr')-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);
create table bonus
(
ename varchar2(10) ,
job varchar2(9) ,
sal number,
comm number
) ;
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;
exit
@pekdc1-vcm-03: [/usr/app/oracle/110203/v04/rdbms/admin]
，