Oracle Error Message
ORA-30440: can’t fast refresh;refresh complete or set event 30441 for partial refresh
Reason for the Error
Both DML and direct-load are performed against detail tables. Fast refresh can only process direct-load inserts.
Solution
Refresh complete or set event 30441 to enable partial refresh with only direct-load inserts