Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Change username in DBA_USERS

Re: Change username in DBA_USERS

From: Radoulov, Dimitre <>
Date: Sat, 1 Oct 2005 19:14:48 +0200
Message-ID: <045801c5c6ab$a7649020$e800a8c0@IBME1D11967173>,F4950_P8_CRITERIA:30020192108317


  I am unable to find the page you are looking of TOM Kyte. Can u send me the URL?

  I was trying cause I knew someone has done this in past. just forgot the "HOW" portion.

  Now the question is what will be the affect of doing this. I didn even find anythinng about this in trace file.

  Is this the simple update for Oracle like any other schema. No way.

  Regards - Chirag    

  On 10/1/05, Radoulov, Dimitre <> wrote:     There should be a reason for Tom Kyte's answer :O)

I'm surprised Tom let the one about updating the sys.user$ table slip by without any chiding. Wouldn't that be a strict no-no anyways?


that would be strictly a no-no -- 100%



      D O N E ..... ! ! ! ! !

      was thinking of changing the ownership column first. 
      But see, this works, with not a single error or warning in TRACE file.
      SQL> select user#,name from user$ where name like 'SCOT%';

           USER# NAME

---------- ------------------------------
59 SCOTT 64 SCOTT1 SQL> update user$ set name='HERMESNEW' where user#=64; 1 row updated. SQL> commit; Commit complete. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 105978600 bytes Fixed Size 453352 bytes Variable Size 79691776 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> select user#,name from user$ where name like 'SCOT%'; USER# NAME
---------- ------------------------------
59 SCOTT SQL> select user#,name from user$ where name like 'HER%'; USER# NAME
---------- ------------------------------
65 HERMES 64 HERMESNEW SQL> select username from dba_users where username like 'HER%'; USERNAME ------------------------------ HERMES HERMESNEW SQL> alter user hermesnew identified by chirag; User altered. SQL> conn hermesnew/chirag Connected. SQL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- BONUS TABLE CHIRAG TABLE DEPT TABLE EMP TABLE SALGRADE TABLE TEMP1 TABLE 6 rows selected. SQL> sho user USER is "HERMESNEW" SQL> Thanx to everyone.... Regards - Chirag On 10/1/05, Chirag DBA < > wrote: 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 < > 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 < > 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).
Received on Sat Oct 01 2005 - 12:17:19 CDT

Original text of this message