From oracle-l-bounce@freelists.org Sat Oct 1 11:45:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j91GjKkC025115 for ; Sat, 1 Oct 2005 11:45:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j91GjF6H025102 for ; Sat, 1 Oct 2005 11:45:15 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0FCBD1F041C; Sat, 1 Oct 2005 11:45:15 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30254-10; Sat, 1 Oct 2005 11:45:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7E9BA1F02F6; Sat, 1 Oct 2005 11:45:14 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=TW79n1zxrZeq5+cIvO/PAhrNRiTCKPJmcXuoOTT4WAKKgf8XV3iUfYSzKs4mY2TQBhgiqiOE3Y3rdVB633ivhX2hYbiYQ15/2QZYr7wi8Eu7Kn0yGsSdomBesh1spUZRcTg0FPs98DPEEEK8N2IvMqjMTUAvekZx4xzjmQnzVNU= Message-ID: <1a3629600510010943x3363c4fcu9c5c048be2cd21b0@mail.gmail.com> Date: Sat, 1 Oct 2005 12:43:19 -0400 From: Chirag DBA To: David Sharples Subject: Re: Change username in DBA_USERS Cc: "Radoulov, Dimitre" , Oracle-L Freelists , Ganesh Raja In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9764_10152738.1128184999457" References: <1a3629600510010859t5b55a5b1odffe73999b115061@mail.gmail.com> <03f301c5c6a4$8df188c0$e800a8c0@IBME1D11967173> <1a3629600510010935j216bdb89taa5bb39d461350c6@mail.gmail.com> X-archive-position: 26207 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chiragdba@gmail.com Precedence: normal Reply-To: chiragdba@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.0 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_9764_10152738.1128184999457 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 wa= y > 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). > > > ------=_Part_9764_10152738.1128184999457 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
hmmmm...!!!
 
Its a large dump, takes more than 5 hrs. so thinking to get it in &quo= t;SHORT WAY".
 
Export problem was because of replicated objects.
 
can afford to have a corruption on my local test database.

rega= rds - chirag
 
On 10/1/05, = David Sharples <davidshar= ples@gmail.com> wrote:
simple, dont do it, not supported, doesnt work and corrupts the data d= ictionary and oracle support would tell you to go away.
 
Any good person will tell you to stop right now and do it the proper w= ay
 
Fromuser / touser export is the only way of doing it, so fix your expo= rt problems.


 
On 10/1/05, = Chirag DBA <chiragdba@gmail.c= om > wrote:=20
Its not a joke and am doing this on test.
 
I remember one incident on LAZYDBAs , where a DBA did programming on U= SER_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).

------=_Part_9764_10152738.1128184999457-- -- http://www.freelists.org/webpage/oracle-l