Hi Team, will Import into a table I am getting the below error message
Error Message
Record 1: Rejected - Error on table MTN_BUNDLES_EXPIRY_MIG, column EXPIRY_DATE_T.
ORA-01840: input value not long enough for date format
The data client provide in .XLs file
My Table Structure is
CREATE TABLE tmp_mtnuga_3g_expiry_mig
(
MSISDN_V VARCHAR2 (50),
expiry_Date_t TIMESTAMP(6) WITH TIME ZONE
status_date_t TIMESTAMP(6) WITH TIME ZONE
GOT_STARTER_PACK_V NUMBER(10)
);
I am using 2 option to import into a table
First option using Toad ---> Import Table -- option here i am getting error like
The format is not matched.
Second option using SQL Loader-->
LOAD DATA
INFILE 'D:\ss\TT-Projects\Customer Apps\Client Dump\3GBundle.csv'
BADFILE 'D:\dd\TT-Projects\Customer Apps\Client Dump\3GBundle.bad'
DISCARDFILE 'D:\dd\TT-Projects\Customer Apps\Client Dump\3GBundle.dsc'
INTO TABLE tmp_mtnuga_3g_expiry_mig
INSERT
(MSISDN_V,
EXPIRY_DATE_T,
STATUS_DATE_T,
GOT_STARTER_PACK_V
)
Please guide me how solve the TimeStamp