Hi!

Is there any way to change the name of an Oracle user ID?

Thanks

Not directly, but it can be done. Export/import (or datapump) is usually how (fromuser/touser).

i didn't explain it well. I mean the field USER_ID from DBA_USERS table, because we have made an import/export of a schema from a database to another. But the USER_ID has changed and we have an application that uses this user_id. Any help?

Thanks

How can you ensure the user ID is the same from database to database? What a blunder in terms of application design.

Hi liquid,
u may try change data in table
- update user$ set user#=A where user#=B;

( create user use first free ID)

But (as say Steve) relation to sys.users table is oddish.