Re: Updating SYS.TS$ to help with transportable tablespace

You already clearly know the perils of updating the data dictionary directly, so I won't repeat all that.

All I would say is that you'd need to be a better person than me to state with any confidence that you have tracked down all the very many dependencies that exist between the highly normalized tables that comprise the data dictionary. And if one hasn't done that, then one can't be certain that what appears to work as a quick update today won't cause catastrophic failure next week, next month or whatever.

As an example of the sort of stuff that goes on, though I realise it's not exactly relevant to what you are doing: did you know that in 9i, you can switch from one Undo tablespace to a new one. But that you should never switch back to the earlier undo tablespace, because data corruption can occur? And, what's more, if you instead drop the original undo tablespace and create a brand new one with merely the same name as the original one, and then switch back to it, the same thing can occur: re-using the same undo tablespace name alone can cause problems (and apparently this is a deliberate design feature, not a bug).

Now if an undo tablespace name stored somewhere in the depths of the data dictionary can wreak such havoc, I wouldn't be too keen on dabbling in ts$ myself.

I think the real issue, though, is the lack of support you'd get from Oracle, on absolutely any topic under the sun, if they ever get wind of what's been done. Even if you ask about an optimizer bug, they'd drop you saying merely that yours in an unsupported installation (cynics might say they look for any opportunity to avoid giving support anyway, so one more excuse won't make any difference... but is it worth it?)

Regards
HJR "Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0305090635.43501128_at_posting.google.com...
> Asked this on ORACLE-L also, but its not a 100% mix between people who
> frequent each and this is an question for me.
>
> BTW, someone on ORACLE-L got rather upset and told me to get my resume
> ready. Dont need that. Not my idea. Not my implementation. Just asking
> about it.
>
> ----------------
>
> My Question:
>
> 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.
Received on Fri May 09 2003 - 16:51:07 CDT