Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: "sqlplus / as sysdba" in 9iR2

Re: "sqlplus / as sysdba" in 9iR2

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 21 Jun 2006 21:43:18 +0800
Message-ID: <44994CF6.50E6@yahoo.com>


meathammer wrote:
>
> On Tue, 20 Jun 2006 15:05:17 +0000, Chuck wrote:
> > 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

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_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------
Received on Wed Jun 21 2006 - 08:43:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US