SQL & PL/SQL

Hi Here is my create table command.... .not sure what is the error . is it any syntax error that is causing the problem . plz suggest

A and B are parent tables ; c is the child table for both A and B . A is the partitioned table.

CREATE TABLE A (
  A_log_id Number NOT NULL,
  A_date_time Date NOT NULL,
  A_category Varchar2(50) NOT NULL,
  A_type Varchar2(50) NOT NULL,
  customer_id Varchar2(20),
  customer_name Varchar2(70),
  usr_login Varchar2(32),
  usr_name Varchar2(100),
  simulate_mode Varchar2(20)
) COMPRESS

PARTITION BY RANGE (A_date_time)

 (PARTITION A_sep_2009 VALUES LESS THAN (TO_DATE('10/01/2009 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_oct_2009 VALUES LESS THAN (TO_DATE('11/01/2009 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_nov_2009 VALUES LESS THAN (TO_DATE('12/01/2009 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_dec_2009 VALUES LESS THAN (TO_DATE('01/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_jan_2010 VALUES LESS THAN (TO_DATE('02/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_feb_2010 VALUES LESS THAN (TO_DATE('03/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_mar_2010 VALUES LESS THAN (TO_DATE('04/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_apr_2010 VALUES LESS THAN (TO_DATE('05/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_may_2010 VALUES LESS THAN (TO_DATE('06/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_jun_2010 VALUES LESS THAN (TO_DATE('07/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_jul_2010 VALUES LESS THAN (TO_DATE('08/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_aug_2010 VALUES LESS THAN (TO_DATE('09/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_sep_2010 VALUES LESS THAN (TO_DATE('10/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_oct_2010 VALUES LESS THAN (TO_DATE('11/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_nov_2010 VALUES LESS THAN (TO_DATE('12/01/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_dec_2010 VALUES LESS THAN (TO_DATE('01/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_jan_2011 VALUES LESS THAN (TO_DATE('02/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_feb_2011 VALUES LESS THAN (TO_DATE('03/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_mar_2011 VALUES LESS THAN (TO_DATE('04/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_apr_2011 VALUES LESS THAN (TO_DATE('05/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_may_2011 VALUES LESS THAN (TO_DATE('06/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_jun_2011 VALUES LESS THAN (TO_DATE('07/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS')),
  PARTITION A_jul_2011 VALUES LESS THAN (TO_DATE('08/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'))
 )



CREATE TABLE B (DATA_KEY VARCHAR2(50),VALUE_TYPE VARCHAR2(10),DATA_TYPE  varchar2(10));

ALTER TABLE  B ADD CONSTRAINT BLOGDATADEFINITION_PK PRIMARY KEY (data_key) ;



CREATE TABLE  C (
  logdata_id Number NOT NULL,
  activity_log_id Number NOT NULL,
  data_key Varchar2(50),
  parameters Varchar2(50),
  ordinal Number,
  text_value varchar2(100),
  integer_value number,
  date_value date,
  boolean_value char(1),
  currency_value Number(20,4),
  CONSTRAINT A_FK FOREIGN KEY (activity_log_id) REFERENCES A( A_log_id ) ON DELETE CASCADE,
  CONSTRAINT B_FK  FOREIGN KEY (data_key) REFERENCES B(DATA_KEY) ON DELETE CASCADE
) COMPRESS
PARTITION BY REFERENCE ( A_log_id );