About table partitioning

wisdomslay

partition by range (sales_date)
(
 partition pt_sales1999_q4 values ​​less than
  (to_date ('01 / 01/2000 ',' DD / MM / YYY '))
  tablespace saleA,
  pctfree 0
  storage (initial 100M next 100M pctincrease 0)
 partition pt_sales2000_q1 values ​​less than
  (to_date ('01 / 04/2000 ',' DD / MM
...............

When creating table partitions in ORACLE, what does pctfree 0 and storage (initial 100M next 100M pctincrease 0) mean? ? ? ?
And what does pt_sales1999_q4 refer to after the partition?
What is saleA behind tablespace?

hzy520cf

SaleA behind tablespace refers to the tablespace that is stored.

whbilly

What does pctfree 0, storage (initial 100M next 100M pctincrease 0) mean?
It indicates the storage of the partition table pt_sales1999_q4, which is initially 100m, and is expanded every 100m

What does pt_sales1999_q4 refer to after partition?

The name of the partition is: pt_sales1999_q4

After the tablespace saleA is the tablespace indicating the partition

panda_ren

partition pt_sales1999_q4 values ​​less than
  (to_date ('01 / 01/2000 ',' DD / MM / YYY '))
  tablespace saleA,
  pctfree 0
  storage (initial 100M next 100M pctincrease 0)

pctfree: reserved space ratio
Data storage parameters in the storage table, initial 100M: initialize 100m next 100M is the next increase
tablespace saleA: indicates the tablespace where the partition data is stored. Each partition specifies a different tablespace. The purpose is to damage a tablespace, but the corresponding partition is unavailable. Other partitions can be used normally

whbilly

pctfree: reserved space ratio
Data storage parameters in the storage table, initial 100M: initialize 100m next 100M is the next increase
tablespace saleA: indicates the tablespace where the partition data is stored. Each partition is assigned a different tablespace in order to damage a certain tablespace, but the corresponding partition is unavailable. Other partitions can be used normally. At the same time, the execution of SQL is improved. speed

wisdomslay

Thank you very much!