Change username in DBA_USERS 2005-10-01 - By Radoulov, Dimitre
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.
There must be the way we can do. ( I think so).
--
http://www.freelists.org/webpage/oracle-l
|
|
