Re: internal error when selecting from V$PWFILE_USERS.

Hi, Amar.

Probably bug 425862. Calling suppport for confirming this is a good idea, as suggested.

If you got the bud, there are currently a couple of workarounds: + Execute the query from svrmgrl.
+ In sqlplus, use an ORDER BY clause with your select statement.

Hope it helps,
Juan Guillermo.

Amar Kumar Padhi wrote:

>
>
> Hi,
> I am getting ora-600 when I give a select from v$pwfile_users from sql*plus.
> The same statement is working when I connect as sysdba in svrmgr30.
> My remote_login_passwordfile is set to 'EXCLUSIVE' and I have used orapwd80 to
> create a password file.
>
> I am not able to think of any remote possibility as to why it should be
> happening. Any ideas? scripts missed out during installation etc. etc.
>
> Thanks,
> Amar
> 00-971-50-7883254
> ts2017_at_emirates.com
> amar_padhi_at_hotmail.com
> amar_padhi_at_musclemail.com
Received on Wed Oct 18 2000 - 06:47:28 CDT