Re: Target is the ORACLE 9i RELEASE2!

"Jim Stern" <jdstern_at_k2services.com> wrote in message news:<ao53lk$g3a$1_at_news.utelfla.com>...
> Dusan,
>
>
> The new hash subpartitioning algorythm is really killer, as is the automated
> rollback space management (one note, choose uniform extends).

In Oracle 9 you don't get to choose a UNIFORM extent size for UNDO tablespaces, it uses an AUTO SEGMENT SIZE.

But for all your other tablespaces choose LMT's with UNIFORM extents.

I think the LIST partitioning is pretty good. "Resumable" is pretty handy, and the ability to EXPORT at the tablespace level.

Also, looks like Oracle's getting ready to phase out Dictionary-Managed Tablespaces. Oh, and if you create a LMT System tablesapce, you won't be able to create DD Managed (not that'd you'd want to)... I wrote a tiny "how-to" article relating to migrating to LMT from DD tablespace... (I see a few published names in this forum...so at the risk of being tossed off at the end of the earth)

http://www.dbasupport.com/oracle/ora9i/segmentmoving.shtml

Also in 9i, Oracle still needs alots of work in the XML area.

That's all for now,

Cheers,

Greg. Received on Mon Oct 14 2002 - 00:43:21 CDT