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%';
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>
