Solved

Oracle SQL load question

Posted on 2014-09-29
1
501 Views
Last Modified: 2014-10-22
I need to upload a datafile to an Oracle database via SQL load process. It is a working system but the SQL load process stopped working.
The control file of the SQL load process looks like the following:

LOAD DATA
INFILE '${DATFILE}'
APPEND
INTO TABLE rnt.incidents
FIELDS TERMINATED BY x'1'
TRAILING NULLCOLS
...
...
...


And the datafile one record is like:

2014-09-07 00:00:17     2014-09-07 00:00:17     Operations       140907-013931  \N      \N      \N


could anyone assist me to understand what the expected delimited in the datafile is, given the control file content of "FIELDS TERMINATED BY x'1'" .. ?
Thanks a lot.
0
Comment
Question by:toooki
1 Comment
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40351369
Have you looked in the docs?

X'hex_string' is a byte string in hexadecimal format

http://docs.oracle.com/cd/E11882_01/server.112/e22490/ldr_concepts.htm#SUTIL984

It means the fields are delimited by a Hex 1.

Granted, I've never seen this but based on information from http://www.asciitable.com/
that is a "Start of Heading" character.

You will likely need a hex editor to view the input file to see if that is the correct character.

>>It is a working system but the SQL load process stopped working.

Please explain what this means.  It was working but then stopped?

If so, what changed?  Please don't say 'nothing'.  Things just don't stop working.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now