v$pwfile_users
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: v$pwfile_users

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    Red face

    Hi,
    Can someone tell me why does Oracle gives a ORA-00600 error when u select from v$pwfile_users view through SQL*Plus.
    If we give select against the v$pwfile_users view through SVRMGR by using internal...it shows me the output.Can anyone tell me the reason for it.

    Regards,
    ROhit Nirkhe

  2. #2
    Join Date
    Mar 2001
    Posts
    11

    Which Version of Oracle You are running on

    Hi There ,

    I can do :

    select * from v$pwfile_users ;

    without any problem in sqlplus. So i was wondering if it is somekind of bug. I am running on 8.1.5

    Regards

    Pankaj Jain

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    Re: Which Version of Oracle You are running on

    Hi,
    I am running Oracle 8i version 8.1.5 on IBM AIX-Unix.Yesterday I gave a query in sql*plus logged in as sys and the instance crashed.The same query if I give as internal it works fine....
    Is there any bug .


    Regards,
    Rohit Nirkhe

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    It is kinda bug. I have confirmed with Oracle when I got the same error. One they upgraded the features, they didn't clean up the old stuff/views(usually Oracle lazy to clean relevant old features when they upgrade the features) which nturn gives the Ora-600 error. You are safe. Don't worry.

    I will try looking into my tar and post any relevant info later...
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width