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: Export / Import from 8i to 9i and locally managed tablespace

Re: Export / Import from 8i to 9i and locally managed tablespace

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 8 Apr 2003 21:51:56 +0100
Message-ID: <3e93366d$0$21988$cc9e4d1f@news.dial.pipex.com>


"Yvan GALAS" <yvan.galas_at_fr.adp.com> wrote in message news:b6um58$oji$1_at_pegase.atos-infogerance.fr...
> Yes sorry to be more precise :
>
> I assume that you are in 9i cause SEGMENT SPACE MANAGEMENT doesn't exist
> in 8i
>
> If you specify : EXTENT MANAGEMENT LOCAL AUTOALLOCATE (Be care of blob
> objects..)
>
> -- first you cannot specify a DEFAULT STORAGE CLAUSE

Indeed not. This is irrelevant since the creator of the segment can specify whatever storage clause they like. In this case the poster told us what the storage clause for the segment was.

> -- second oracle activate SEGMENT SPACE MANAGEMENT AUTO with a inital
> extent of 1M (If your block size is 16K or more)

As Howard has said automatic segment space management has absolutely nothing to do with extent sizes. The tablespace block size is equally irrelevant.

> If you specify LOCAL and want to allocate your DEFAULT STORAGE CLAUSE
> as usual you must specify SEGMENT SPACE MANAGEMENT MANUAL

No, No and No. Did I mention that you were incorrect? Extent management local (uniform or auto whatever) defines your tablespace level storage extent sizes - and enforces them. The DEFAULT STORAGE clause specifies what you would like (unless anyone else thinks they know better).

> All of this information is in ORACLE DATABASE CONCEPTS.

Where exactly.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Tue Apr 08 2003 - 15:51:56 CDT

Original text of this message

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