Re: Change username in DBA_USERS

Tom Kyte is your best friend, try with new_schema + synonyms:

h**p://tinyurl.com/8yn86

RHTHTT,
Dimitre

• Original Message ----- From: Chirag DBA To: David Sharples Cc: Radoulov, Dimitre ; Oracle-L Freelists ; Ganesh Raja Sent: Saturday, October 01, 2005 6:43 PM Subject: Re: Change username in DBA_USERS

hmmmm...!!!

Its a large dump, takes more than 5 hrs. so thinking to get it in "SHORT WAY". Export problem was because of replicated objects.

can afford to have a corruption on my local test database.

regards - chirag

On 10/1/05, David Sharples <davidsharples_at_gmail.com> wrote: simple, dont do it, not supported, doesnt work and corrupts the data dictionary and oracle support would tell you to go away.

Any good person will tell you to stop right now and do it the proper way

Fromuser / touser export is the only way of doing it, so fix your export problems.

On 10/1/05, Chirag DBA <chiragdba_at_gmail.com > wrote: Its not a joke and am doing this on test.

I remember one incident on LAZYDBAs , where a DBA did programming on USER_ID and then required to change the USER_ID. He did it someway, but I am unable to recollect.

There must be the way we can do. ( I think so).

--

http://www.freelists.org/webpage/oracle-l Received on Sat Oct 01 2005 - 11:57:35 CDT