Home » RDBMS Server » Server Utilities » SQL loader not loading any data
icon1.gif  SQL loader not loading any data [message #212425] Fri, 05 January 2007 04:51 Go to next message
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 #212428 is a reply to message #212425] Fri, 05 January 2007 05:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is quite a different syntax you are using in your control file.
Post the table DDL,some sample data.
Re: SQL loader not loading any data [message #212429 is a reply to message #212428] Fri, 05 January 2007 05:04 Go to previous messageGo to next message
nomi
Messages: 9
Registered: November 2005
Location: Pakistan
Junior Member

Attached is some sample data, please note that when i copy the data into a new text file it works fine, but i can't do it with 6million data
  • Attachment: test.txt
    (Size: 1.96KB, Downloaded 162 times)
Re: SQL loader not loading any data [message #212430 is a reply to message #212428] Fri, 05 January 2007 05:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
Reported By: nomi On: Fri, 05 January 2007 06:02 In: RDBMS Server » Server Utilities » SQL loader not loading any data
Reason i hace tried all options i can but data is still not loading. Anyhow when i cope the data into a new text file, it works but i can't do it 6 million records

Never report the posting to get attention. It will actually work the other way.
Re: SQL loader not loading any data [message #212436 is a reply to message #212430] Fri, 05 January 2007 05:17 Go to previous messageGo to next message
nomi
Messages: 9
Registered: November 2005
Location: Pakistan
Junior Member

ok, did you find any reason
Re: SQL loader not loading any data [message #212445 is a reply to message #212436] Fri, 05 January 2007 05:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> when i copy the data into a new text file it works fine
It may be a formatting error with file then. Is there a carriage return involved?
You have'nt posted your DDL yet. Post your sqlldr logfile also

Re: SQL loader not loading any data [message #212446 is a reply to message #212445] Fri, 05 January 2007 05:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I have no case to reproduce here. Smile
Re: SQL loader not loading any data [message #212448 is a reply to message #212446] Fri, 05 January 2007 05:55 Go to previous messageGo to next message
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 190 times)
Re: SQL loader not loading any data [message #212452 is a reply to message #212448] Fri, 05 January 2007 06:06 Go to previous messageGo to next message
nomi
Messages: 9
Registered: November 2005
Location: Pakistan
Junior Member

OK, when i reduced the length of column, here is another error, VALUE TOO LARGE,

have a look at all attached file (
test.txt Data file
log.txt
bad.txt
  • Attachment: BAD.TXT
    (Size: 1.95KB, Downloaded 148 times)
Re: SQL loader not loading any data [message #212453 is a reply to message #212452] Fri, 05 January 2007 06:07 Go to previous messageGo to next message
nomi
Messages: 9
Registered: November 2005
Location: Pakistan
Junior Member

log
  • Attachment: LOG.TXT
    (Size: 5.05KB, Downloaded 186 times)
Re: SQL loader not loading any data [message #212454 is a reply to message #212453] Fri, 05 January 2007 06:08 Go to previous messageGo to next message
nomi
Messages: 9
Registered: November 2005
Location: Pakistan
Junior Member

data
  • Attachment: test.txt
    (Size: 1.95KB, Downloaded 146 times)
Re: SQL loader not loading any data [message #212744 is a reply to message #212454] Mon, 08 January 2007 02:15 Go to previous message
nomi
Messages: 9
Registered: November 2005
Location: Pakistan
Junior Member

anyone ahs any idea
Previous Topic: impdp aborting
Next Topic: Imoprt and Export
Goto Forum:
  


Current Time: Sat Dec 03 22:04:28 CST 2016

Total time taken to generate the page: 0.06813 seconds