OraFAQ Forum: Server Utilities » 4 Rows not loaded because all WHEN clauses were failed ?

Home » RDBMS Server » Server Utilities » 4 Rows not loaded because all WHEN clauses were failed ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

4 Rows not loaded because all WHEN clauses were failed ? [message #73777]

Mon, 12 July 2004 04:52

neema
Messages: 20
Registered: March 2004

Junior Member

Plz c my CTL file..

LOAD DATA
INFILE *
APPEND
INTO TABLE SCOTT.DEPT
WHEN (01) = 'H' and (01) = 'T' and (3:7) = '1999'
(
DEPTNO "my_db_sequence.nextval",
DNAME POSITION(01:2) CHAR,
LOC POSITION(3:7) CHAR
)
BEGINDATA
He1999
Tr1999
Na1999

Y it fails???

thanx 4 ur reply.

Report message to a moderator

Re: 4 Rows not loaded because all WHEN clauses were failed ? [message #73787 is a reply to message #73777]

Tue, 13 July 2004 01:12

Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA

Senior Member

It fails because the first character cannot be H and T at the same time. Please try the corrected control file below.

LOAD DATA
INFILE *
APPEND
INTO TABLE SCOTT.DEPT
WHEN (01) = 'H' and (3:6) = '1999'
(
DEPTNO "my_db_sequence.nextval",
DNAME POSITION(01:2),
LOC POSITION(3:6)
)
INTO TABLE SCOTT.DEPT
WHEN (01) = 'T' and (3:6) = '1999'
(
DEPTNO "my_db_sequence.nextval",
DNAME POSITION(01:2) CHAR,
LOC POSITION(3:6) CHAR
)
BEGINDATA
He1999
Tr1999
Na1999

Report message to a moderator

Re: 4 Rows not loaded because all WHEN clauses were failed ? [message #73788 is a reply to message #73787]

Tue, 13 July 2004 02:24

neema
Messages: 20
Registered: March 2004

Junior Member

Yes It workd!

Report message to a moderator

Previous Topic:	Difficulty running EXP/IMP utility
Next Topic:	Import overwriting data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 08:30:12 CST 2024