Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Locally managed tablespaces. Safe?

Re: Locally managed tablespaces. Safe?

From: James Williams <techsup_at_mindspring.com>
Date: Mon, 29 Jan 2001 12:23:23 GMT
Message-ID: <3a756062.823183@news.mindspring.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US