Linux环境下Oracle的scott演示模式所在目录:
$ORACLE_HOME/rdbms/admin/utlsampl.sql,
添加步骤:
在sql*plus执行(注意在sys用户下)
@$ORACLE_HOME/rdbms/admin/utlsampl.sql
(@表示在sql*plus执行脚本)
完成后自动断开连接,然后用scott进入,密码默认为tiger。
以下是实际执行结果:
SQL> show user
USER is "SYS"
SQL> @$ORACLE_HOME/rdbms/admin/utlsampl.sql
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@RedHat4 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 6 05:10:15 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> conn scott/tiger
Connected.
SQL> select * from emp;