Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Locally managed tablespaces. Safe?
tgphelps50_at_my-deja.com wrote:
Just make sure your OEM software can handle them. In 8.1.5 there was only a one way conversion. In 8.1.6 and higher you should be able to use the Oracle supplied package to go either way.
Try your TEMP tables first.
>I'm considering experimentation with locally managed tablespaces
>(LMTs). I've read most of what's available in the standard
>documentation, but I'm wondering if there are any contrary opinions on
>this feature.
>
>What particularly worries me is that there is no redo for the bitmaps
>that track the allocations. The fact that Oracle provides the
>dbms_space_admin package might be construed as evidence that problems
>really do arise.
>
>Am I wrong to think that a server crash (or other problem) might leave
>the bitmaps hosed, and needing repair, resulting in data loss or
>corruption?
>
>Has anyone actually had any bad experiences with LMTs that (s)he'd like
>to share? Should I be leery of LMTs, or "just go for it"?
>
>
>Sent via Deja.com
>http://www.deja.com/
Received on Mon Jan 29 2001 - 06:23:23 CST