4 Replies Latest reply: Oct 16, 2013 9:41 PM by rp0428 RSS

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

    996454

      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:

       

      ftp://species_test:AbvPLJSz@pubftp.waikatoregion.govt.nzAbvPLJSz@pubftp.waikatoregion.govt.nz

       

       

      ftp://species_test:AbvPLJSz@pubftp.waikatoregion.govt.nz

       

      I'm using oracle 11g and sql developer 3.2.20.09