SQL*Plus Enhancements in Oracle Database 10g(一)

在本地服务器用操作系统验证登录时10g 支持 sqlplus / as sysdba

9i 下不支持sqlplus / as sysdba  只支持 sqlplus '/ as sysdba'  sqlplus "/ as sysdba"

sv-dev-oracle-01*82*ora9i-/home/oracle>sqlplus / as sysdba
Usage: SQLPLUS [ [

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jul 9 11:28:59 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
sv-dev-oracle-01*82*ora9i-/home/oracle>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jul 9 11:29:07 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

10g 下支持sqlplus / as sysdba . sqlplus ' /as sysdba' .  sqlplus "/ as sysdba":

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 9 04:59:37 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

 


 

请使用浏览器的分享功能分享到微信等