DROP MATERIALIZED VIEW LOG ON sales;

CREATE MATERIALIZED VIEW LOG ON sales
  WITH ROWID, SEQUENCE
  (prod_id, cust_id, time_id, channel_id, promo_id, quantity_sold, amount_sold)
  INCLUDING NEW VALUES ;

DROP MATERIALIZED VIEW LOG ON customers;

CREATE MATERIALIZED VIEW LOG ON customers
  WITH ROWID, SEQUENCE
  (cust_id,cust_first_name,cust_last_name,cust_gender,cust_year_of_birth
  ,cust_marital_status,cust_street_address,cust_postal_code,cust_city
  ,cust_state_province,country_id,cust_main_phone_number,cust_income_level
  ,cust_credit_limit,cust_email)
  INCLUDING NEW VALUES;



--This one will be used later.

DROP MATERIALIZED VIEW LOG ON products;

CREATE MATERIALIZED VIEW LOG ON products
  WITH ROWID, SEQUENCE
  (prod_id,prod_name,prod_desc,prod_subcategory,prod_subcategory_desc
  ,prod_category,prod_category_desc,prod_weight_class,prod_unit_of_measure
  ,prod_pack_size,supplier_id,prod_status,prod_list_price,prod_min_price)
  INCLUDING NEW VALUES;
