Re: RE: Renaming tablespace by updating SYS.TS$

to be perfectly honest. management made the decision and is aware of the risks. Im not 100% opposed. That database is partially dispensible. Replacing it is not difficult. Reinstall. Re-import transported tablespaces. Not too big of a deal. Its just a staging server. No users touch it.

Was hoping for something better. Guess there is none. Anyone got Larry Ellison's number? I want to give him a call and recommend a 'RENAME TABLESPACE' command. Without it, tablespace transportation functionality is greatly reduced.
>
> From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> Date: 2003/05/09 Fri PM 05:12:02 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: Renaming tablespace by updating SYS.TS$
>
> Been doing this before you got there? Welcome to the wonderful world of DBA
> politics. If your boss got his/her promotion for this clever idea, then you
> want to be diplomatic. You are correct that if it works now the company
> won't want to spend thousands of dollars to replace it (the Shareplex
> recommendation). On the other hand, if it breaks in the future, you could
> end up with the blame, particularly if you didn't warn them it was
> vulnerable.
> First, I would get the lay of the land. Find out how much emotional
> investment the company has in this method. Whose idea was it? I think the
> replies today have given you some suggestions of the vulnerabilities. Then
> you may want to consider a note to your management outlining the issues and,
> if possible, suggest some alternatives. Whether they decide to act on your
> suggestions isn't in your control.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Friday, May 09, 2003 9:32 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We are doing this to make our transportable tablespace process simpler. We
> import the transported tablespace. Drop the old one. Rename the new one.
>
> Anyone else do this? Any pitfuls other than the shock and awe of us touching
> TS$? I know its not supported.
>
> For those of you who hate this idea, they've been doing it since before I
> got here. Just looking for outside opinions on this.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).