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@(protected)> 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@(protected) > 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.
