navarannan -7 Newbie Poster

Hi Im using the following trigger to refresh my mview.

BEGIN
  DBMS_SNAPSHOT.REFRESH(
    LIST                 => 'EQUIPMENT_FEATURES_MVIEW'
   ,PUSH_DEFERRED_RPC    => TRUE
   ,REFRESH_AFTER_ERRORS => FALSE
   ,PURGE_OPTION         => 1
   ,PARALLELISM          => 0
   ,ATOMIC_REFRESH       => TRUE);
END;

I change the table from which the mview is created and does a commit, it throws the following error..

error ORA-04092: cannot COMMIT in a trigger 
ORA-06512: at "SYS.DBMS_SNAPSHOT", 
line 2732 ORA-06512: at "SYS.DBMS_SNAPSHOT", 
line 2712 ORA-06512: at "PE_TEST_SCHEMA.EQUIPMENT_FEATURE_T1", 
line 3 ORA-04088: error during execution of trigger 'PE_TEST_SCHEMA.EQUIPMENT_FEATURE_T1'

Any help would be very really appreciated