Solved

Oracle SQL load question

Posted on 2014-09-29
1
529 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 77

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

623 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