Create Scott user and sample data with the system's own script Utlsampl.sql

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. Create a script path $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

After the completion of the establishment will automatically exit Sqlplus, please re-login either., I am here to delay a lot of time, I hope the peer to see my article, do not take more detours.

Run Sqlplus/nolog

Sql> Conn Scott/tiger

Connected.

Sql> select * from tab;

Tname

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

DEPT

Emp

BONUS

Salgrade

View all of the current user's

Create Scott user and sample data with the system's own script Utlsampl.sql