This content has been marked as final. Show 0 replies
Well, in Oracle 9i you have to use :
sqlplus "sys as sysdba"
if you want to specify the user at the command line.
excellent, that is what I was looking for. Thanks.
You already solved your problem, I give you another syntax to login as sysdba
# sqlplus "/ as sysdba"
in 10g, you can remove the quotes
sqlplus / as sysdba
On a related note, how do i connect as SYSDBA using iSQLPLUS. When I use connect SYS/<password> as SYSDBA; inside iSQLPLUS, I get this error:
SP2-0927: CONNECT AS SYSDBA or AS SYSOPER not allowed through iSQL*Plus URL
The same works inside SQLPLUS
you must use a special screen
check your sqlplus manual