Re: Convert TS from dictionary to locally managed

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:WFxla.11900$1s1.187323_at_newsfeeds.bigpond.com...
> "Howard J. Rogers" <howardjr20002_at_yahoo.com.au> wrote in message

>
> Hi Howard,
>
> You make it seem all so easy and straight forward.
>
> A bit of a problem though.
>
> If you have large quantities of data to "move" and you have high
> availability requirements, then it's not so easy as the table locks become
> preventative.

If you have high availability requirements, then you shouldn't (probably) be bothering to convert to LMTs in the first place. Presumby, if you're contemplating monkeying around with Orace-supplied packages and procedures to achieve the task, you've got some 'unavailable' time up your sleeve.

And since there's no requirement to move every table in one sitting, the 'move and do it properly' approach can be done over an extended period of time, to fit in with what maintenance windows you have.

I think the more serious obection is the presence of LONGs.

Regards
HJR
>
> If you simply can't afford the unavailability of data during the
conversion
> process, although not ideal, the above procedure is a possible "half-way"
> solution to convert to LMT and reduce DD issues . If objects are only
> growing and are not likely to be dropped, it has even more appeal. If such
> availability restrictions apply, the dbms_redefinition procedure is
another
> workable, albeit messy, solution.
>
> Hopefully 10i will provide for the "easy" online movement of heap tables
> ....
>
> Cheers
>
> Richard
>
>
Received on Fri Apr 11 2003 - 17:24:15 CDT