运行了
SQL> @D:\app\orcl\product\12.1.0\dbhome_1\RDBMS\ADMIN\scott.sql
SQL> Rem Copyright (c) 1990 by Oracle Corporation
SQL> Rem NAME
SQL> REM UTLSAMPL.SQL
SQL> Rem FUNCTION
SQL> Rem NOTES
SQL> Rem MODIFIED
SQL> Rem gdudey 06/28/95 - Modified for desktop seed database
SQL> Rem glumpkin 10/21/92 - Renamed from SQLBLD.SQL
SQL> Rem blinden 07/27/92 - Added primary and foreign keys to EMP and
DEPT
SQL> Rem rlim 04/29/91 - change char to varchar2
SQL> Rem mmoore 04/08/91 - use unlimited tablespace priv
SQL> Rem pritto 04/04/91 - change SYSDATE to 13-JUL-87
SQL> Rem Mendels 12/07/90 - bug 30123;add to_date calls so language inde
pendent
SQL> Rem
SQL> rem
SQL> rem $Header: utlsampl.sql 7020100.1 94/09/23 22:14:24 cli Generic<base> $ s
qlbld.sql
SQL> rem
SQL> SET TERMOUT OFF
------解决方案--------------------
这个脚本时干什么用的?
LZ是否只是想添加个用户?
------解决方案--------------------
完全可以从有scott用户的数据库中使用expdp导出,然后再导入进LZ的数据库不就好了,简单方便,还不容易出错.
------解决方案--------------------
创建用户:
connect system/manager
Create user user50 identified by user50 default tablespace users temporary tablespace temp;
grant connect, resource to user50;
------解决方案--------------------
导出后为dmp文件,然后使用impdp导入现在的数据库
------解决方案--------------------
创建一个scott用户,然后 把里面的语句贴出来执行