Duplicate Usernames

Hi,

I ran 'select username from dba_users' on one of my databases and received DUPLICATE usernames for all users. How do I resolve this and why did it happen in the first place?

AC

select other columns, like account_status for example, I guess you'll find a difference between your users ...

do the case of these usernames differ.

Hi,

IS user_id same in duplicate usernames?

Thanx

Yes, everything is exactly identical, case, account_no, password (CODED of course). As I wrote, 'select * from dba_users order by username' generates identical columns.

If you are really "seeing" a duplicate username, for sure there are trailing "white spaces" in one of them.

Use replace(username,' ','#') and look at it.

It seems someone has played with the database. Kind of Import with ignore=Y option or Inserting in to the same table.

Bounce back the database if possible.

Otherwise, remove the duplicate rows.

Thanks,

Thanks, The data owned by these users are also duplicated. I'm contemplating re-installation of Oracle and restoration from the last backup before the incident. It's a big job and I'm not looking forward to it unless someone out there has another alternative.

AC

Why would you need to re-innstall Oracle

Just restoring from an previous backup should be suffcient

I can drop the tablespaces and import a previous backup but I'm not sure what caused the problem in the first place and how deep the damage/corruption is.

I'm not looking forward to the re-installation neither am I willing to have to face the same problem after drop .... import. Re-installation seems to be the better of the two evils.

AC