DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: duplicate dba_users

  1. #21
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Of course, it makes sence perfectly. FYI, DBA_USERS is not a table, it is a view which among others joins table user$ to table user_astatus_map - so if you have double entries in user_astatus_map it is normal for DBA_USERS to show duplicate users!

    Simply delete all duplicate rows from user_astatus_map and DBA_USERS will stop showing duplicate users.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  2. #22
    Join Date
    Jun 2002
    Posts
    22

    duplicate dba_users

    dear jmodic,

    I will test on the test server and get back to you.

    Regards,

    Naren
    naren

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