urgent...need help

[Trina]

I queried to see the list of all username in the database. However,
I see duplicate user accounts. How can I fix it? Below is the sample.

SQL> select username, created
2 from dba_users
3 order by 1;

USERNAME CREATED
------------------------------ ---------
DBSNMP 16-MAY-02
DBSNMP 16-MAY-02
OUTLN 16-MAY-02
OUTLN 16-MAY-02
SYS 16-MAY-02
SYS 16-MAY-02
SYSTEM 16-MAY-02
SYSTEM 16-MAY-02
TRACESVR 16-MAY-02
TRACESVR 16-MAY-02

[Trina]

forgot to add more to it...I looked into metalink and
could not fine the solution....Has anyone have this
problem before?

[thanigai]

It is strange.....
Check selecting one user from dba_users...
Thanks.
Thanigaivasan.

[samdba]

Someone must have imported the table with IGNORE=Y

[kkvr]

Hi

I think you have run the catalog.sql or catproc.sql more than one time, this is one reason, so if possible recreate the database(take a full export-create new database-import back). This will work.

Good luck!

[anandkl]

re-execute the query
select username,to_char(created,'dd/mm/yy hh24:mi:ss') from dba_users;

to get to know that time differece between the records insert.

regards
anandkl

[patel_dil]

Sounds strange and interesting.

Does select * from dba_users also shows exact duplicate values for all columns? Try creating a new test user and see how many record it inserts.

[pando]

connect sys and query user$

[Trina]

I recreated the database and reimported it. It worked.
No duplicated users. Thanks everyone.