Jul 1 2008, 09:57 AM
Is there any way to change the name of an Oracle user ID?
Jul 1 2008, 09:59 AM
Not directly, but it can be done. Export/import (or datapump) is usually how (fromuser/touser).
Jul 1 2008, 10:09 AM
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?
Jul 1 2008, 10:52 AM
How can you ensure the user ID is the same from database to database? What a blunder in terms of application design.
Jul 2 2008, 02:48 AM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here