-
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
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
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.
svk
-
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,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
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
Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|