首页 > 代码库 > 利用系统自带脚本utlsampl.sql创建scott用户及样本数据

利用系统自带脚本utlsampl.sql创建scott用户及样本数据

SQL>  select * from v$version;


BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE    11.2.0.1.0      Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production


SQL> select USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,CREATED from dba_users where USERNAME = ‘SCOTT‘;


no rows selected

2.创建 脚本路径$ORACLE_HOME/rdbms/admin/utlsampl.sql


SQL> @?/rdbms/admin/utlsampl.sql

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

建立完成以后会自动退出sqlplus,请重新登录既可.,我在这里耽误了好多时间,希望同行看到我的文章后,不要多走弯路。

运行sqlplus /nolog

SQL> conn scott/tiger

Connected.

SQL> select * from tab;

TNAME

------------------------

DEPT

EMP

BONUS

SALGRADE

查看当前用户的所有的


利用系统自带脚本utlsampl.sql创建scott用户及样本数据