Re: HELP!!! Change User ID

Bad luck ....
You can't change it, as it is used in numerous data dictionary tables by Oracle itself. You will inevitably screw up the data dictionary. And of course, updating the dictionary directly is unsupported. The only option you have (if you are not changing platform at the same time) is moving the physical database, issue alter database backup controlfile to trace on the old database first, move it, edit the trace file into a correct create controlfile script for your new database etc. I'm not trying to preach, and you probably are aware of your mistake. I never fell into the temptation of using the user_id because I knew beforehand what I would be getting into.

Hth,

Sybrand Bakker, Oracle DBA

Dave Bucholtz <buch1734_at_kettering.edu> wrote in message news:Pine.GSO.3.95q.990729211302.10761A-100000_at_nova.kettering.edu...
> Hopefully someone out there can help me. I have this database that I am
> moving to a new Oracle server. Only problem is I used the user_id as a
> key in some of my tables. Now, when I move the database to the new Oracle
> box, the ids for the users don't match up, and I have too many to change
> to make it feasible to use the new numbers. Can anyone tell me how to
> change the user ID from the one given by the system to a new one. PLEASE
> HELP!!!
>
> If you respond, please send a copy to my buch1734_at_kettering.edu address
> since I don't check this newsgroup to often. (Also, if you wouldn't mind,
> send a note to my pager so I can check the email right away. I know it is
> asking a lot, but I REALLY NEED this!!! thanks. Pager:
> pagedave_at_hp9000.chc-chimes.com)
>
> Dave Bucholtz
>
> buch1734_at_kettering.edu- School
> dbucholtz_at_sprynet.com - Home
> pagedave_at_hp9000.chc-chimes.com - Pager
> david.bucholtz_at_computerhorizons.com - Work Number 1
> nacho_at_hp9000.chc-chimes.com - Work Number 2
>
Received on Thu Jul 29 1999 - 23:48:11 CDT