howto update meterialized view log's pctused larger than 0 on oracle 184.108.40.206
Date: Tue, 4 Mar 2008 02:35:24 -0800 (PST)
I want to create a meterialized view log with pctused larger than 0, but failed.
My oracle is 220.127.116.11.
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 18.104.22.168? Is this a bug of 22.214.171.124? Received on Tue Mar 04 2008 - 04:35:24 CST