SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Daniel TaitOct 16 2013 — edited Oct 16 2013

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.nz AbvPLJSz@pubftp.waikatoregion.govt.nz

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

I'm using oracle 11g and sql developer 3.2.20.09

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 13 2013

Added on Oct 16 2013

#11g, #import, #sql-developer

4 comments

28,973 views