SQL> CREATE TABLE traffic_hit
  2  (
  3    site_id                                varchar2(40),
  4    country                                  varchar2(40),
  5    country_carrier_id               number,
  6    code_type                                number,
  7    page_request                             number default 0,
  8    valid_page_request               number default 0,
  9    ad_request                               number default 0,
 10    valid_ad_request                 number default 0,
 11    page_impressions                         number default 0,
 12    ad_impressions                   number default 0,
 13    request_date                             timestamp
 14    )
 15    partition by list(to_char(request_date,'D'))
 16    (
 17    partition traffic_hit_sun values (1),
 18    partition traffic_hit_mon values (2),
 19    partition traffic_hit_tue values (3),
 20    partition traffic_hit_wed values (4),
 21    partition traffic_hit_thu values (5),
 22    partition traffic_hit_fri values (6),
 23    partition traffic_hit_sat values (7)
 24    ) ;
  partition by list(to_char(request_date,'D'))
                           *
ERROR at line 15:
ORA-00907: missing right parenthesis