FreeLists / oracle-l / Re: Change username in DBA_USERS

[Chirag DBA <chiragdba@xxxxxxxxx>]

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 <cichomitiko@xxxxxxxxx> wrote:
>
> There should be a reason for Tom Kyte's answer :O)
>   <quote>
>
> 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?
>
> Kashif
>
>
>   *Followup:*
>
> that would be strictly a no-no -- 100%
>
> </quote>
>   HI,
> Dimitre
>
> ----- Original Message -----
> *From:* Chirag DBA <chiragdba@xxxxxxxxx>
> *To:* David Sharples <davidsharples@xxxxxxxxx>
> *Cc:* Radoulov, Dimitre <cichomitiko@xxxxxxxxx> ; Oracle-L 
> Freelists<oracle-l@xxxxxxxxxxxxx>; Ganesh
> Raja <ganesh.raja@xxxxxxxxx>
> *Sent:* Saturday, October 01, 2005 7:00 PM
> *Subject:* Re: Change username in DBA_USERS
>
>  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 <chiragdba@xxxxxxxxx> 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 <davidsharples@xxxxxxxxx > 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@xxxxxxxxx > 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).
> > > >
> > >
> >
>