howto update meterialized view log's pctused larger than 0 on oracle 9.2.0.1

Hi

   I want to create a meterialized view log with pctused larger than 0, but failed.

   My oracle is 9.2.0.1.

   First, I use

         create materialized view log on tbl_term_inf tablespace tjsplog;

   then through toad, I find the pctused is 0. This will cause my table space grow

   fill under large pressure.

   Then, I use

         create materialized view log on tbl_term_inf tablespace tjsplog pctfree 5 pctused 60;

   the pctfree is changed, but pctused is still 0.

   Then I use

         alter materialized view log on tbl_term_inf pctused 60;    still not work.

   How can I change this parameter in 9.2.0.1?    Is this a bug of 9.2.0.1? Received on Tue Mar 04 2008 - 04:35:24 CST