SQL> desc trip_performance
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TRIP_NUM                                  NOT NULL NUMBER
 TRIP_VERSION                              NOT NULL NUMBER
 CAR_INIT                                  NOT NULL VARCHAR2(4)
 CAR_NUM                                   NOT NULL VARCHAR2(10)
 SHIPPER_ID                                         NUMBER
 SHIPPER                                            VARCHAR2(75)
 CONSIGNEE_ID                                       NUMBER
 CONSIGNEE                                          VARCHAR2(75)
 SHIP_DATE                                          VARCHAR2(6)
 ORIGIN_CITY                                        VARCHAR2(30)
 ORIGIN_STATE                                       VARCHAR2(2)
 DESTINATION_CITY                                   VARCHAR2(30)
 DESTINATION_STATE                                  VARCHAR2(2)
 LE_STATUS                                          VARCHAR2(1)
 COMMODITY_NAME                                     VARCHAR2(50)
 EQUIPMENT_GROSS_WEIGHT                             VARCHAR2(8)
 EQUIPMENT_TARE_WEIGHT                              VARCHAR2(8)
 EQUIPMENT_ACT_NET_WEIGHT                           VARCHAR2(8)
 EQUIPMENT_EST_NET_WEIGHT                           VARCHAR2(8)
 UNITOFWEIGHT                                       VARCHAR2(10)
 CAREOFPARTY                                        VARCHAR2(75)
 CAREOFPARTY_ID                                     NUMBER
 FREIGHTPAYER                                       VARCHAR2(75)
 FREIGHTPAYER_ID                                    NUMBER
 BENEFICIALOWNER                                    VARCHAR2(75)
 BENEFICIALOWNER_ID                                 NUMBER
 SCHEDULE_ID                                        NUMBER
 ROUTE1                                             VARCHAR2(4)
 ROUTE2                                             VARCHAR2(4)
 ROUTE3                                             VARCHAR2(4)
 JUNC1                                              VARCHAR2(10)
 JUNC2                                              VARCHAR2(10)
 JUNC3                                              VARCHAR2(10)
 TRIP_START_EVENT                                   VARCHAR2(3)
 TRIP_START_DATE                                    VARCHAR2(24)
 TRIP_PLC_DATE                                      VARCHAR2(24)
 TRIP_PLA_DATE                                      VARCHAR2(24)
 TRIP_CLOSE_EVENT                                   VARCHAR2(3)
 TRIP_CLOSE_DATE                                    VARCHAR2(24)
 TRANSIT_HOURS                                      FLOAT(126)
 TERMINAL_HOURS                                     FLOAT(126)
 DESTINATION_DWELL_HOURS                            FLOAT(126)
 BAD_STATUS                                         VARCHAR2(1)
 BOR_STATUS                                         VARCHAR2(1)
 FTPS_SCHEDULEETADATETIME                           VARCHAR2(50)
 FTPS_REQDELIVERYDATE                               VARCHAR2(20)
 FTPS_RECEIVEDDATE                                  VARCHAR2(26)
 FTPS_CURRENTSTATUS                                 VARCHAR2(10)
 FTPS_LASTSCHEDEVENTSEQ                             NUMBER(38)
 ORD_DATE                                           VARCHAR2(26)
 LAST_COMMENT                                       DATE
 LAST_COMMENT_ORG_ID                                NUMBER
 NON_SERVICE_DAYS                                   NUMBER
 NON_SERVICE_DAYS_TYPE                              VARCHAR2(20)
 FTPS_FREIGHTPAYER                                  VARCHAR2(50)
 FTPS_FREIGHTPAYER_ID                               NUMBER
 FTPS_BENEFICIALOWNER                               VARCHAR2(50)
 FTPS_BENEFICIALOWNER_ID                            NUMBER
 FTPS_CAREOFPARTY                                   VARCHAR2(50)
 FTPS_CAREOFPARTY_ID                                NUMBER
 FTPS_NOTIFYPARTY                                   VARCHAR2(50)
 FTPS_NOTIFYPARTY_ID                                NUMBER
 FTPS_PROPERTYOWNER                                 VARCHAR2(50)
 FTPS_PROPERTYOWNER_ID                              NUMBER
 UNLOADING_TIME                                     NUMBER
 LAST_CARRIER                                       VARCHAR2(4)
 NOTIFYPARTY_ID                                     NUMBER
 PROPERTYOWNER_ID                                   NUMBER
 STCC_CODE                                          VARCHAR2(20)
 NOTIFY_PARTY                                       VARCHAR2(75)
 PROPERTY_OWNER                                     VARCHAR2(75)
 ORDER_NUMBER                                       VARCHAR2(50)
 AAR_CAR_TYPE                                       VARCHAR2(4)
 BOL_NUMBER                                         VARCHAR2(30)
 WAYBILL_NUMBER                                     VARCHAR2(30)
 FLEET_CODE                                         VARCHAR2(50)
 SUB_FLEET_CODE                                     VARCHAR2(50)
 FLEET_CUSTOMER                                     VARCHAR2(50)
 FLEET_COMMODITY                                    VARCHAR2(50)
 DOW_GMID                                           VARCHAR2(20)
 DOW_GMID_DESCRIPTION                               VARCHAR2(50)
 GALLONS                                            VARCHAR2(15)
 ACCOUNTOF_PARTY                                    VARCHAR2(75)
 ACCOUNTOF_PARTY_ID                                 NUMBER
 CUSTOMS_BROKER                                     VARCHAR2(75)
 SHIPMENT_CATEGORY_1                                VARCHAR2(50)
 SHIPMENT_CATEGORY_2                                VARCHAR2(50)
 CUSTOMS_BROKER_ID                                  NUMBER
 PURCHASE_ORDER_NUMBER                              VARCHAR2(50)
 FTPS_ACCOUNTOFPARTY                                VARCHAR2(75)
 FTPS_ACCOUNTOFPARTY_ID                             NUMBER
 SALES_DEPARTMENT                                   VARCHAR2(50)
 PRODUCT_GROUP                                      VARCHAR2(50)
 PRODUCT                                            VARCHAR2(50)
 PROFIT_CENTER                                      VARCHAR2(50)
 COST_CENTER                                        VARCHAR2(50)
 EXCL_FROM_DEMM_CALC                                CHAR(1)
 ROUTE4                                             VARCHAR2(10)
 ROUTE5                                             VARCHAR2(10)
 ROUTE6                                             VARCHAR2(10)
 JUNC4                                              VARCHAR2(10)
 JUNC5                                              VARCHAR2(10)
 LEG_1_SCH_DAYS                                     NUMBER(8,2)
 LEG_1_ACTUAL_DAYS                                  NUMBER(8,2)
 INTERCHANGE_1_DAYS                                 NUMBER(8,2)
 LEG_2_SCH_DAYS                                     NUMBER(8,2)
 LEG_2_ACTUAL_DAYS                                  NUMBER(8,2)
 INTERCHANGE_2_DAYS                                 NUMBER(8,2)
 LEG_3_SCH_DAYS                                     NUMBER(8,2)
 LEG_3_ACTUAL_DAYS                                  NUMBER(8,2)
 INTERCHANGE_3_DAYS                                 NUMBER(8,2)
 LEG_4_SCH_DAYS                                     NUMBER(8,2)
 LEG_4_ACTUAL_DAYS                                  NUMBER(8,2)
 INTERCHANGE_4_DAYS                                 NUMBER(8,2)
 LEG_5_SCH_DAYS                                     NUMBER(8,2)
 LEG_5_ACTUAL_DAYS                                  NUMBER(8,2)
 INTERCHANGE_5_DAYS                                 NUMBER(8,2)
 LEG_6_SCH_DAYS                                     NUMBER(8,2)
 LEG_6_ACTUAL_DAYS                                  NUMBER(8,2)
 BAD_ORDER_DAYS                                     NUMBER(8,2)
 LEG_1_START_EVENT_CODE                             VARCHAR2(10)
 LEG_1_START_EVENT_LOCATION                         VARCHAR2(50)
 LEG_1_END_EVENT_CODE                               VARCHAR2(10)
 LEG_1_END_EVENT_LOCATION                           VARCHAR2(50)
 LEG_2_START_EVENT_CODE                             VARCHAR2(10)
 LEG_2_START_EVENT_LOCATION                         VARCHAR2(50)
 LEG_2_END_EVENT_CODE                               VARCHAR2(10)
 LEG_2_END_EVENT_LOCATION                           VARCHAR2(50)
 LEG_3_START_EVENT_CODE                             VARCHAR2(10)
 LEG_3_START_EVENT_LOCATION                         VARCHAR2(50)
 LEG_3_END_EVENT_CODE                               VARCHAR2(10)
 LEG_3_END_EVENT_LOCATION                           VARCHAR2(50)
 LEG_4_START_EVENT_CODE                             VARCHAR2(10)
 LEG_4_START_EVENT_LOCATION                         VARCHAR2(50)
 LEG_4_END_EVENT_CODE                               VARCHAR2(10)
 LEG_4_END_EVENT_LOCATION                           VARCHAR2(50)
 LEG_5_START_EVENT_CODE                             VARCHAR2(10)
 LEG_5_START_EVENT_LOCATION                         VARCHAR2(50)
 LEG_5_END_EVENT_CODE                               VARCHAR2(10)
 LEG_5_END_EVENT_LOCATION                           VARCHAR2(50)
 LEG_6_START_EVENT_CODE                             VARCHAR2(10)
 LEG_6_START_EVENT_LOCATION                         VARCHAR2(50)
 LEG_6_END_EVENT_CODE                               VARCHAR2(10)
 LEG_6_END_EVENT_LOCATION                           VARCHAR2(50)
 CUSTOMSBROKER_2                                    VARCHAR2(75)
 CUSTOMSBROKER_2_ID                                 NUMBER
 FORWARDER                                          VARCHAR2(75)
 FORWARDER_ID                                       NUMBER

SQL> 

Index Creation script
---------------------
CREATE INDEX IX_TRIP_PERF_RELEASE_DATE 
ON TRIP_PERFORMANCE (SUBSTR("TRIP_CLOSE_DATE",1,10))
TABLESPACE "SHIPX_INDEX06"
PARALLEL 5