Change username in DBA_USERS 2005-10-01 - By Chirag DBA
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@(protected)> 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@(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).
> > >
> >
>
<div>D O N E ..... ! ! ! ! ! </div>
<div> </div>
<div>was thinking of changing the ownership column first. </div>
<div>But see, this works, with not a single error or warning in TRACE file.<
/div>
<div>
<p>SQL> select user#,name from user$ where name like 'SCOT%';</p>
<p> USER# NAME<br>-- ---- -- -- ---- ---- ---- ---- ---
----<br> 59 SCOTT<br>  
; 64 SCOTT1</p>
<p>SQL> update user$ set name='HERMESNEW' where user#=64;</p>
<p>1 row updated.</p>
<p>SQL> commit;</p>
<p>Commit complete.</p>
<p>SQL> shutdown immediate;<br>Database closed.<br>Database dismounted.<br
>ORACLE instance shut down.<br>SQL> startup<br>ORACLE instance started.</p>
<p>Total System Global Area 105978600 bytes<br>Fixed Size
453352 bytes<br>Variable Size
79691776 bytes<br>Database
Buffers 25165824
bytes<br>Redo Buffers
667648 bytes
<br>Database mounted.<br>Database opened.<br>SQL> select user#,name from
user$ where name like 'SCOT%';</p>
<p> USER# NAME<br>-- ---- -- -- ---- ---- ---- ---- ---
----<br> 59 SCOTT</p>
<p>SQL> select user#,name from user$ where name like 'HER%';</p>
<p> USER# NAME<br>-- ---- -- -- ---- ---- ---- ---- ---
----<br> 65 HERMES<br>
64 HERMESNEW</p>
<p>SQL> select username from dba_users where username like 'HER%';</p>
<p>USERNAME<br>-- ---- ---- ---- ---- ---- --<br>HERMES<br>HERMESNEW</p>
<p>SQL> alter user hermesnew identified by chirag;</p>
<p>User altered.</p>
<p>SQL> conn hermesnew/chirag<br>Connected.<br>SQL> select * from tab;</p>
<p>TNAME  
;
TABTYPE CLUSTERID<br>-- ---- ---- ---- ---- ---- -- -- ---- -- ---- --<br
>BONUS
TABLE<br>CHIRAG
TABLE<br>DEPT
TABLE
<br>EMP
TABLE<br>SALGRADE
TABLE<br>TEMP1  
;
TABLE</p>
<p>6 rows selected.</p>
<p>SQL> sho user<br>USER is "HERMESNEW"<br>SQL></p>
<p>Thanx to everyone....</p>
<p>Regards - Chirag<br></p></div>
<div><span class="gmail_quote">On 10/1/05, <b class="gmail_sendername">Chirag
DBA</b> <<a href="mailto:chiragdba@(protected)">chiragdba@(protected)</a>>
wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>hmmmm...!!! </div>
<div> </div>
<div>Its a large dump, takes more than 5 hrs. so thinking to get it in "
;SHORT WAY".</div>
<div> </div>
<div>Export problem was because of replicated objects.</div>
<div> </div>
<div>can afford to have a corruption on my local test database.<br><br>regards
- chirag </div>
<div><span class="e" id="q_106ad10ef8ed1008_1">
<div> </div>
<div><span class="gmail_quote">On 10/1/05, <b class="gmail_sendername">David
Sharples</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href
="mailto:davidsharples@(protected)" target="_blank">davidsharples@(protected)
</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>simple, dont do it, not supported, doesnt work and corrupts the data
dictionary and oracle support would tell you to go away.</div>
<div> </div>
<div>
<div>Any good person will tell you to stop right now and do it the proper way<
/div>
<div> </div></div>
<div>Fromuser / touser export is the only way of doing it, so fix your export
problems.</div>
<div><span>
<div><br><br> </div>
<div><span class="gmail_quote">On 10/1/05, <b class="gmail_sendername">Chirag
DBA</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href=
"mailto:chiragdba@(protected)" target="_blank">chiragdba@(protected)</a>
> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Its not a joke and am doing this on test.</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>There must be the way we can do. ( I think so).</div></blockquote></div><
/span></div></blockquote></div><br></span></div></blockquote></div><br>
|
|
