Duplicate Usernames

[ac]

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

[pipo]

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

[gpsingh]

do the case of these usernames differ.

[samdba]

Hi,

IS user_id same in duplicate usernames?

Thanx

[ac]

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.

[svk]

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.

[samdba]

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,

[ac]

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

[brhynold]

Why would you need to re-innstall Oracle

Just restoring from an previous backup should be suffcient

[ac]

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