Re: sys and system in 9i

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Fri, 04 Jul 2003 15:34:41 -0700
Message-ID: <4inNa.119861$MJ5.48239@fed1read03>

Ed Wong wrote:
> I've migrated an instance from 8.1.7 to 9.2.0. After the migration, I
> can connect to system by connection string "system/password_at_tnsnames"
> but can't do that as sys. I got an error ORA-28009: connection to sys
> should be as sysdba or sysoper. Is it a normal behavior?

yES

>
> If I need to do "connect / as sysdba" instead of connecting
> sys/password, why oracle doesn't make "system" account the same way?

Because Oracle decided to make them different. Received on Fri Jul 04 2003 - 17:34:41 CDT