4 Replies Latest reply on Oct 17, 2013 2:41 AM by rp0428

    ORA-02290 error: check contraint violated when trying to import data from excel into Oracle

    Daniel Tait

      Hi There


      I'm having trouble importing data from a Microsoft Excel (xlsx) file into a table using sql developer

      import data wizard.


      The create table statement is:


      CREATE TABLE species_test (

          species_id NUMBER,

          species_type VARCHAR2(255),

          CONSTRAINT species_type_check CHECK (species_type IN ('SIGNIFICANT_FLORA', 'SIGNIFICANT_fAUNA'))




      I get an ORA-02290 error: check constraint 'species_type_check' violated. Insert failed for rows 1 through to 50.



      The Excel file I'm having trouble importing can be found at the following ftp site:







      I'm using oracle 11g and sql developer