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 tablespace

Re: Locally managed tablespace

From: David Pomphrey <High.Flight_at_btinternet.com>
Date: Sat, 28 Apr 2001 01:39:33 +0100
Message-ID: <3AEA1145.2B39@btinternet.com>

Less hassle with differet NEXT, PCTINCREASE storage parameters for tables and indexes.

Faster as tablespace stores a 'map' of its contents, rather than centralised maps (which are universally accessed).

D.P.

Agung Kurniawan wrote:
>
> Hi all,
>
> In Oracle 8i there's a new feature called locally managed tablespace. Could
> anyone tell me the advantages and disadvantages of this new feature against
> the old one (data dictionary-managed tablespace)?
>
> thanks,
>
> Agung
Received on Fri Apr 27 2001 - 19:39:33 CDT

Original text of this message

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