Re: Locally Managed Tablespace for System Tabespace ?

In article <aguf2q$1ak$1_at_lust.ihug.co.nz>, "Howard says...
>

snip

>If...then..elseif...else..whatever...but also....god knows...
>
>I particularly enjoyed this sentence from the same documentation:
>
>"Oracle recommends that the total initial space allocated for the SYSTEM
>tablespace be a minimum of 5 megabytes."
>
>Ha!ha!ha!ha!ha!...Deep breathing...Ha!ha!ha!ha!ha!

Well, hey, what's wrong with that? Have you tried fitting the SYSTEM tablespace into LESS than 5 Mb? ;)

Let me find the page ref and log it as a doc bug.

>
>And the last time I created a 5Mb system tablespace was...., er.... , 1958.
>
>Around the time you were celebrating your 21st, Richard!!

Oohh, cutting! (True though.)

Pete
>
>Best Regards
>HJR
>
>
>"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
>news:2mbY8.34691$Hj3.104871_at_newsfeeds.bigpond.com...
>> Hi Howard,
>>
>> Clarification please.
>>
>> Are you suggesting that a 'CREATE DATABASE ZIGGY;' creates a System LMT
>> (default) in 9.2. If so, what is the option to create a System DMT ?
>> Curious.
>>
>> PS. Hoping my 9.2 CDs will arrive in post tomorrow !
>>
>> Thanks
>>
>> Richard
>>
>> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
>> news:agoqqi$clj$1_at_lust.ihug.co.nz...
>> >
>> > "Ora" <ora_geek_at_yahoo.com> wrote in message
>> > news:fa5d6718.0207122046.86b4197_at_posting.google.com...
>> > > Is it possible to have Locally Managed Tablespace (LMT) for SYSTEM
>> > Tablespace also ?
>> > >
>> >
>> > Not until 9i Release 2, when an LMT SYSTEM tablespace is in fact the
>> > default. Until then, it was utterly impossible to create SYSTEM as
>locally
>> > managed, despite Oracle's own documentation (and one or two posters
>here)
>> > stating otherwise.
>> >
>> > > If so , how can we convert an existing Dictionary Managed SYSTEM
>> > Tablespace to LMT ?
>> >
>> > You can't. I don't even think it's possible in 9i Release 2 (converting,
>I
>> > mean). I think you have to create it as locally managed in the first
>place
>> > (and remember, as I say, it's locally managed by default anyway).
>> >
>> > As it is, you really don't want to convert *any* tablespaces to LMT. The
>> > conversion procedure supplied by Oracle doesn't do a particularly good
>> job,
>> > and it's much better wherever possible to create new LMT tablespaces
>from
>> > scratch and use the MOVE command to put your existing segments into it.
>> When
>> > the old dictionary stuff is empty, drop it and have done.
>> >
>> > Regards
>> > HJR
>> >
>> >
>> > >
>> > > OrA
>> >
>> >
>>
>>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Mon Jul 15 2002 - 12:28:47 CDT