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

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sun, 11 May 2003 20:33:20 +0100
Message-ID: <3ebeb861$1_2@mk-nntp-1.news.uk.worldonline.com>

"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.

FWIW, I'd very strongly recommend you don't do this. It will cause too many problems. Leave the DD alone, and if you have problems call support.

Regards,
Paul Received on Sun May 11 2003 - 14:33:20 CDT