"sqlplus / as sysdba" in 9iR2
meathammer
-------------
$ sqlplus / as sysdba
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
in XE:
-------
$ sqlplus / as sysdba
sys@XE>
So "sqlplus / as sysdba" works differently in 9iR2 vs XE.
Is this the "normal" behavior under 9iR2 ?
Chuck
What's XE?
Were these both done on the same o/s? Try...
sqlplus '/ as sysdba'
In unix space is the argument delimted but sqlplus wants the "/ as
sysdba" to be a single argument so the spaces need to be escaped.
hpuxrac
Yes.
XE is version 10 which includes a syntax change to support the "sqlplus
/ as sysdba". Before that you had to do it differently.
meathammer
> What's XE?
>
> Were these both done on the same o/s? Try...
>
> sqlplus '/ as sysdba'
>
> In unix space is the argument delimted but sqlplus wants the "/ as
> sysdba" to be a single argument so the spaces need to be escaped.
XE is the free "Express Edition"
http://www.oracle.com/technology/products/database/xe/index.html
OS is Linux.
as I experienced and "hpuxrac" pointed out,
pre-10g one must do this: $ sqlplus "/ as sysdba"
10g/XE one can just: $ sqlplus / as sysdba
Connor McDonald
XE is (in effect) 10g, which is where the support for
sqlplus / as sysdba
without the quotes came in.
hth
Connor
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_...@yahoo.com
"Semper in excremento, sole profundum qui variat."
------------------------------------------------------------