Return-Path: <root@fatcity.cts.com>
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164])
 by naude.co.za (8.11.2/8.11.2) with SMTP id g7OBf0a03129
 for <oracle-l@naude.co.za>; Sat, 24 Aug 2002 07:41:00 -0400
Received: from fatcity.UUCP (uucp@localhost)
 by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id EAA15413;
 Sat, 24 Aug 2002 04:36:18 -0700 (PDT)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004BF0D0; Sat, 24 Aug 2002 03:53:19 -0800
Message-ID: <F001.004BF0D0.20020824035319@fatcity.com>
Date: Sat, 24 Aug 2002 03:53:19 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: Rachel Carmichael <wisernet100@yahoo.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Rachel Carmichael <wisernet100@yahoo.com>
Subject: Re: Set unused column to normal
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Mladen,

while I appreciate your volunteering to help, it's okay... I've already
broken all his fingers and threatened to "bobbetize" him if he did that
to any database I had access to. (what, me violent? nah!)

Dan -- THIS is one of the reasons I carry those knitting needles around
<G>

Rachel

--- Mladen Gogala <mgogala@adelphia.net> wrote:
> Rachel, can you give me the email address of your user?
> I'd like to send him the following procedure for renaming users,
> I'm sure that both of you will love it:
> 
> 1) Change the user name: 
>    update sys.user$  set name = 'NewUserName'  where
> name='OldUserName';
> 2) Shutdown/startup the database 
> 3) Reset the renamed users password: 
>        alter user NewUserName identified by NewPassword;    
> 4) Check for synonyms pointing back the old user name: 
>         select  owner, synonym_name,table_name,db_link from
> dba_synonyms
>   where table_owner = 'OldUserName'; 
> 5)  Drop and recreate these synonyms using NewUserName instead of
>    OldUserName for the table_owner.  
> 
> Wouldn't you, as a DBA, love a user coming to you with a suggestion
> like the one
> above? Please no threats to me or my pets.
> 
> 
> On 2002.08.23 21:28 Rachel Carmichael wrote:
> > today our data warehouse modeler came to me and said he had
> misnamed a
> > column and how could he change it.... 
> > 
> > I said, since we are on 9.2, it's a simple alter table command.
> > 
> > He said "oh I found something on the web about a way to go into the
> > data dictionary and you change a system table....."
> > 
> > after I stopped screaming at him, he agreed that *I* would be the
> DBA
> > and handle all database work and he would be the modeler. It helped
> > that I had my foot on his throat at the time.
> > 
> > He said he bookmarked that page and would send me the url. And then
> I'm
> > gonna beat up the person who posted THAT.
> > 
> > sigh.... maybe I should add that to the Top 20 Mistakes?
> > 
> > 
> > --- Joe Testa <jtesta@dmc-it.com> wrote:
> > > besides its just being stupid, newbies/kiddies, even the
> experienced 
> > > DBAs dont do this stuff on the sand database.
> > > 
> > > joe
> > > 
> > > 
> > > Jared.Still@radisys.com wrote:
> > > 
> > > >Not only is it not supported, it has been know on
> > > >occasion to trash a database.
> > > >
> > > >I tried it years ago, several procedures could not
> > > >be recompiled after doing so.
> > > >
> > > >An instructor from one Oracle class said he blew
> > > >away a database by doing this. 
> > > >
> > > >Caveat emptor.
> > > >
> > > >Jared
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >"Sinardy Xing" <SinardyXing@bkgcomsvc.com>
> > > >Sent by: root@fatcity.com
> > > >08/22/2002 07:53 PM
> > > >Please respond to ORACLE-L
> > > >
> > > > 
> > > >        To:     Multiple recipients of list ORACLE-L
> > > <ORACLE-L@fatcity.com>
> > > >        cc: 
> > > >        Subject:        RE: Set unused column to normal
> > > >
> > > >
> > > >Hi George,
> > > >
> > > >This is the step:
> > > >
> > > >0. SOP = Backup your DB before you make any changes
> > > >
> > > >1a. What is your column name :_________________
> > > >1b. What is your column name :_________________ 
> > > >    The order of your column that you drop is very important (I
> mean
> > > if 
> > > >they are in the same table)
> > > >
> > > >2. Query dba_unused_col_tabs
> > > >                 Take note the information of those unused
> columns
> > > >
> > > >3. Query col$(obj#, col#, name, intcol#, property)
> > > >   Query tab$(obj#, cols, intcols, property)
> > > >                 Optional
> > > >                                 Query obj$(obj#, name, subname,
> > > status)
> > > >
> > > >4. modify col$
> > > >                 If you see name = SYS_bla_bla_bla_bla, property
> =
> > > 32800 
> > > >then
> > > >                 set 
> > > >                                 name = your column_name 
> > > >                                 property = 0
> > > >                                 col# = max(col#) + 1
> > > >
> > > >   repeat this step if you have more than 1 columns
> > > >                 the one your drop first should have smaller
> rowid
> > > compare 
> > > >to the second one
> > > >
> > > >5. modify tab$
> > > >                 select obj# from obj$ where name=your table
> name
> > > >
> > > >                 select tab$  <- step3
> > > >                 where obj#=the one you get above
> > > >
> > > >                 set cols = max_columns
> > > >                     intcols = max_columns
> > > >                     property = 0
> > > >
> > > >
> > > >
> > > >This is not supported by Oracle make sure you know what you are
> > > doing. 
> > > >Check metalink
> > > >article by Mike Ault
> > > >
> > > >
> > > >Sinardy
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >-----Original Message-----
> > > >[mailto:George.Geordi@ci.austin.tx.us]
> > > >Sent: 22 August 2002 18:41
> > > >To: Sinardy Xing
> > > >
> > > >
> > > >Thank you very much for your reply. I did not drop them yet. How
> can
> > > I
> > > >recover those..?
> > > >
> > > >-----Original Message-----
> > > >Sent: Wednesday, August 21, 2002 9:18 PM
> > > >To: George.Geordi@ci.austin.tx.us
> > > >
> > > >
> > > >Hi George,
> > > >
> > > >
> > > >Have you drop those columns that you mark unsued?
> > > >
> > > >if yes then you cannot recover them
> > > >
> > > >check your dba_unsued_col_tabs (count will tell you how many
> unsued 
> > > >columns
> > > >you have that we can recover)
> > > >
> > > >
> > > >Sinardy
> > > >
> > > > 
> > > >
> > > >
> > > >
> > > >-----Original Message-----
> > > >[mailto:George.Geordi@ci.austin.tx.us]
> > > >Sent: 21 August 2002 04:00
> > > >To: Sinardy Xing
> > > >
> > > >
> > > >Hi,
> > > >                 I need some help. I set some columns in my
> table to
> > > 
> > > >unused. Is there
> > > >any way, can I make those back to normal? Thanks
> > > >
> > > 
> > > 
> > > 
> > > -- 
> 
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100@yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).