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用户及样本数据
原文：http://3474247.blog.51cto.com/3464247/1876399