optimize tablespace
From: <Unknown>
Date: 1995/07/24
Message-ID: <3uvm0n$bse_at_saphir.jouy.inra.fr>#1/1
Date: 1995/07/24
Message-ID: <3uvm0n$bse_at_saphir.jouy.inra.fr>#1/1
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
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 :
Attributes : CodCountry NUMBER(3) primary key
NamCountry CHAR(20)
CodCont NUMBER(2) foreign key
NamCont CHAR(20)
E-Mail -> lafon_at_msdos.montpellier.inra.fr
Received on Mon Jul 24 1995 - 00:00:00 CEST