CREATE TABLE bkp_trteevents ( stream_id NUMBER(38,0) NOT NULL, streamrow NUMBER(38,0) NOT NULL, ctx_id NUMBER(38,0) NOT NULL, mtx_id NUMBER(38,0), guidingcparty_id NUMBER(38,0) NOT NULL, datatype_id NUMBER(38,0), eventclass_id NUMBER(38,0), timestamp NUMBER(38,0), servicebegindate DATE, serviceenddate DATE, servicetime NUMBER(38,0), amount NUMBER(38,8), callingnumber VARCHAR2(31), callednumber VARCHAR2(63), connectednumber VARCHAR2(63), cpartyrole_id NUMBER(38,0), guidingcpaccount_id NUMBER(38,0), guidingapinstance_id NUMBER(38,0), guidingapname_id NUMBER(38,0), guidingcitem_id NUMBER(38,0), directguidingquery_id NUMBER(38,0), connectioncount NUMBER(38,0), entrytype VARCHAR2(1), direction NUMBER(38,0), callingprefix_id NUMBER(38,0), calledprefix_id NUMBER(38,0), connectedprefix_id NUMBER(38,0), networkaccessnumber_id NUMBER(38,0), recurringevent_id NUMBER(38,0), indirectguidingrule_id NUMBER(38,0), destinationprefixtable_id NUMBER(38,0), classificationtable_id NUMBER(38,0), usercitem_id NUMBER(38,0), usereventclass_id NUMBER(38,0), isinternalevent VARCHAR2(1), externalconnection_id NUMBER(38,0), errormessage_id NUMBER(38,0), fieldn01 NUMBER(38,8), fieldn02 NUMBER(38,8), fieldv01 VARCHAR2(31), fieldv02 VARCHAR2(31), fieldv03 VARCHAR2(31), fieldv04 VARCHAR2(31), fieldn03 NUMBER(38,8), fieldn04 NUMBER(38,8), fieldn05 NUMBER(38,8), fieldn06 NUMBER(38,8), fieldn07 NUMBER(38,8), fieldn08 NUMBER(38,8), fieldn09 NUMBER(38,8), fieldn10 NUMBER(38,8), fieldn11 NUMBER(38,8), fieldn12 NUMBER(38,8), fieldv05 VARCHAR2(63), fieldv06 VARCHAR2(63), fieldv07 VARCHAR2(63), fieldv08 VARCHAR2(63), fieldv09 VARCHAR2(103), fieldv10 VARCHAR2(103), fieldv11 VARCHAR2(103), fieldv12 VARCHAR2(103), fieldd01 DATE, fieldd02 DATE, fieldd03 DATE, fieldd04 DATE, fieldd05 DATE, recurringdate_id NUMBER(38,0), recurringprevcalculatedto DATE, recurringbillcycledef_id NUMBER(38,0), recurringratingelementdef_id NUMBER(38,0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE BKP_TYTAN_2005 STORAGE ( BUFFER_POOL DEFAULT ) PARTITION BY RANGE (SERVICEBEGINDATE) SUBPARTITION BY HASH (GUIDINGCPARTY_ID) ( PARTITION p_2005_01 VALUES LESS THAN (TO_DATE('2005-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE BKP_TYTAN_2005 STORAGE ( BUFFER_POOL DEFAULT ) SUBPARTITIONS 8 STORE IN (BKP_TYTAN_2005));