SQL & PL/SQL

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!

import into table with null

RobeenApr 9 2019 — edited Apr 9 2019

Oracle Database 12.2.0

RHEL 7.4

Hello,

I am getting

INSERT INTO SESSIONPERUSERID (SESSIONPORTNO, USERACTIVE, BILLINGPHONENO, USERID, EMAIL, MOBILE, PORTLOCKEDON, SESSIONSTARTTIME, SESSIONENDDATE, PACKAGENAME) VALUES (' FTTH-FL-01 0/17/1/32',1,4890661,'myt/131590-2','"mishrasoopal@myt.mu,58241536,FTTH-FL-01 0/17/1/32,2019-04-07 06:08:27,2019-04-08 06:08:27,MyT_10M_FUP','','','','','');

--Insert failed for row 95498

--Line contains invalid enclosed character data or delimiter at position 91.

--Row 95,498

INSERT INTO SESSIONPERUSERID (SESSIONPORTNO, USERACTIVE, BILLINGPHONENO, USERID, EMAIL, MOBILE, PORTLOCKEDON, SESSIONSTARTTIME, SESSIONENDDATE, PACKAGENAME) VALUES (' FTTH-FL-03 0/12/6/43',1,6961851,'myt/13374-1','titodvo@hotmail.com','54990340','"FTTH-FL-03 ,,,,,','','','');

--Insert failed for row 191422

--Line contains invalid enclosed character data or delimiter at position 58.

--Row 191,422

INSERT INTO SESSIONPERUSERID (SESSIONPORTNO, USERACTIVE, BILLINGPHONENO, USERID, EMAIL, MOBILE, PORTLOCKEDON, SESSIONSTARTTIME, SESSIONENDDATE, PACKAGENAME) VALUES (' FTTH-RH-02 0/7/7/14',1,4641017,'myt/jorio','"djpc@intnet.com','','','','','');

--Insert failed for row 191423

--Line contains invalid enclosed character data or delimiter at position 67.

--Row 191,423

INSERT INTO SESSIONPERUSERID (SESSIONPORTNO, USERACTIVE, BILLINGPHONENO, USERID, EMAIL, MOBILE, PORTLOCKEDON, SESSIONSTARTTIME, SESSIONENDDATE, PACKAGENAME) VALUES ('" ,57535107,FTTH-RH-02 0/7/7/14,43562.01333,43563.01333,MyT_10M_FUP',NULL,NULL,'','','','','','','');

DDL of table

CREATE TABLE "BIREPORT"."SESSIONPERUSERID"

( "SESSIONPORTNO" VARCHAR2(40 BYTE),

"BILLINGPHONENO" NUMBER(10,0),

"USERID" VARCHAR2(30 BYTE),

"EMAIL" VARCHAR2(50 BYTE),

"MOBILE" NUMBER(10,0),

"PORTLOCKEDON" VARCHAR2(50 BYTE),

"SESSIONSTARTTIME" VARCHAR2(20 BYTE),

"SESSIONENDDATE" VARCHAR2(20 BYTE),

"PACKAGENAME" VARCHAR2(50 BYTE),

"USERACTIVE" NUMBER(5,0)

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS NOLOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "DWH_RECON_TBS" NO INMEMORY ;

Can anyone pls advise

Thanks,

Joe

Added on Apr 9 2019

5 comments

1,594 views