Re: optimize tablespace

<Unknown> wrote:
>
>Hi,
>
>
> In my database, I have 65 tables (all are in the tablespace SYSTEM).
> How optimize my tablespace creating tablespaces ?
> Could you give me an example with this parameters ?
>
> Table name : COUNTRY
> Attributes : CodCountry NUMBER(3) primary key
> NamCountry CHAR(20)
> CodCont NUMBER(2) foreign key
> NamCont CHAR(20)
>
>
> What are the values parameters for the option DEFAULT STORAGE ?
> Values for PCTFREE and PCTUSED?
>
> The good optimisation is to create a tablespace for one table ?
>
>Thanks for your response.
>
>
>Please reply by E-Mail :
>E-Mail -> lafon_at_msdos.montpellier.inra.fr
Hi,

No need to have a tablespace for each table. You can specify the tablespace for the table and the indexes on primary keys upon creation (i.e. in the create statement, see your SQL language manual).

You should use a different tablespace than SYSTEM. and better have one each for data and indexes.

ttyl Received on Fri Jul 28 1995 - 00:00:00 CEST