Re: SQL

 You're fairly close, what you need to do is:

    sqlplus sys/password as SYSDBA

SYSDBA is Role, so you are effectively doing an ALTER SESSION as you log in.

Michael Rose
mmrose_at_home.com

• Original Message ----- From: "Poosapati Varma" <psgkv_at_yahoo.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, November 06, 2000 4:55 PM Subject: SQL

> Hi guys,
>
> When i login to sqlplus using sys/password
> and i issue archive log list, why doesnt it display
> the result? And when i say SQL>connect internal
> and when i execute 'archive log list' it gives me the
> result set. Can anyone tell me what i have to do.
> inorder to set the sql work without using connect
> internal.
>
> on Windows 2000 Oracle 8.1.6
Received on Mon Nov 06 2000 - 20:41:31 CST