 SQL loader not loading any data [message #212425] |
Fri, 05 January 2007 04:51  |
nomi
Messages: 9
Registered: November 2005
Location: Pakistan
|
Junior Member |
|
|
Hi all,
I'm facing a problem while loading data into ora 10g, when i try to load data, the sql loader loads data successfully, log file seems to be ok but when i query the data all the records are null, as shown below:
select * from jazz_unsold_intransit_tmp;
REGION LOCATIONFROM LOCATIONTO MOBILENO IMSI PACKAGEPLANCODE ISSUANCEDATE REGION_DMP CITY CONN_TYPE LOCATION_TYPE
’žM
17 rows selected.
and my control file looks as this:
LOAD DATA
INFILE 'C:\MFloat\intransit\test.txt'
insert
INTO TABLE jazz_unsold_intransit_tmp
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
--(STORE ,LOCATION ,MTN ,MTNDATE ,GRN ,CITY ,MOBILE ,PACKAGEPLANCODE ,GRNDATE ,RegionName)
(mobileno,
ISSUANCEDATE,
region_dmp,
location_type,
PACKAGEPLANCODE,
locationfrom,
LocationTo)
Any idea.......!!!!!!!!!!!!!!!!!
[Updated on: Fri, 05 January 2007 05:00] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: SQL loader not loading any data [message #212448 is a reply to message #212446] |
Fri, 05 January 2007 05:55  |
nomi
Messages: 9
Registered: November 2005
Location: Pakistan
|
Junior Member |
|
|
Table is as below:
create table JAZZ_UNSOLD_INTRANSIT_TMP
(
REGION VARCHAR2(255),
LOCATIONFROM VARCHAR2(50),
LOCATIONTO VARCHAR2(50),
MOBILENO VARCHAR2(255),
IMSI VARCHAR2(50),
PACKAGEPLANCODE VARCHAR2(50),
ISSUANCEDATE VARCHAR2(50),
REGION_DMP VARCHAR2(50),
CITY VARCHAR2(255),
CONN_TYPE VARCHAR2(255),
LOCATION_TYPE VARCHAR2(255)
)
and attached is log file
-
Attachment: LOG.TXT
(Size: 1.99KB, Downloaded 1145 times)
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
