跳转到主内容
极星编程网:以代码为星,赴技术山海!

Linux环境下添加Oracle的scott账户

Linux环境下oracle的scott演示模式所在目录:$ORACLE_HOME/rdbms/admin/utlsampl.sql,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;

相关文章