That would be very tricky thing to do. If you have the same usernames in DBA_USERS, even if you try to export - how do you know which of these users you will be getting the data from??

The more interesting thing is how did you do that? Oracle suppose to refuse to create new username is user or role with such name already exists:

SQL> create user system identified by manager;
create user system identified by manager
*
ERROR at line 1:
ORA-01920: user name 'SYSTEM' conflicts with another user or role name



Very puzzled,

clio_usa - OCP 8/8i/9i DBA

Visit our Web Site