12-11-2008
You specify the format of the input data using a sqlldr control (ctl) file. Assuming that having six fields does not violate table constraints, then this will work just fine.
read about ctl files here:
SQL Loader Utility
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
i am getting the following error when i am using sql loader.
SQL*Loader: Release 8.1.7.4.0 - Production on Tue Apr 19 13:00:07 2005
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach
ORA-12535:... (4 Replies)
Discussion started by: sveera
4 Replies
2. Shell Programming and Scripting
Hi Guys,
I am looking to develop a SQL Loader script that would bascially allow the user to have a txt file (or such) as an input file containing .sql scripts procedures, triggers, bascially anything against a database that could then be run automatically.
Let me break it down a bit more,... (2 Replies)
Discussion started by: LiquidChild
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I am trying to load the records in a .txt file into the data base using SQL loader. I gave:
$ sqlldr user/pass@DB control=filename.ctl log =mylog.log
It throwed the following error:
SQL*Loader-297: Invalid syntax or bind variable in SQL string for column STATUS.
ORA-01756: quoted... (2 Replies)
Discussion started by: risshanth
2 Replies
4. Shell Programming and Scripting
hi all
i am new to shell scripting.
i have 35 flat files delimited files that i have to load in to a table.
i was asked to create a shell script that loads the data into the table...
could you please help me if you have a script.
Also .. how to create logs files...does my sql... (3 Replies)
Discussion started by: rajesh_tns
3 Replies
5. Shell Programming and Scripting
Hi Frnds,
I wanto load the data thats in data file with comma(,) delimited.
it throw this errors
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified
Plz look at my file... (3 Replies)
Discussion started by: Gopal_Engg
3 Replies
6. UNIX for Dummies Questions & Answers
HI Experts,
We have a ksh file named ldr_empdelta.ksh and it is having the SQL*LOADER script as follows.
print "LOAD DATA" > $WEDB_GEN/ldrscan.ctl
print "INFILE '"$LED_SCAN"/delta/led_del.dat'" >> $WEDB_GEN/ldrparms.ctl
print "TRUNCATE" >> $WEDB_GEN/ldrscan.ctl
print "PRESERVE BLANKS" >>... (1 Reply)
Discussion started by: ajaykumarkona
1 Replies
7. Shell Programming and Scripting
All,
Below is the code written when sql loader loads the data:
$ORACLE_EXEC_PATH/sqlldr userid=$user_passwd control=$CNTR_FILES/invoice.ctl log=$LOG_FILES/$INVOICE_FILE.log bad=$ER
ROR_FILES/$INVOICE_FILE.bad data=$DATA_FILES/$INVOICE_FILE silent=FEEDBACK direct=false errors=50000
rc=$?... (1 Reply)
Discussion started by: Oracle_User
1 Replies
8. UNIX for Dummies Questions & Answers
Which is the UNIX command to get the SQL Loader Help??:confused: (1 Reply)
Discussion started by: venkatesh sunil
1 Replies
9. UNIX for Dummies Questions & Answers
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
10. UNIX for Dummies Questions & Answers
HI Experts,
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
the table.
Also i... (1 Reply)
Discussion started by: sam1234
1 Replies
LEARN ABOUT DEBIAN
gen-ctl-io
GEN-CTL-IO(1) libctl GEN-CTL-IO(1)
NAME
gen-ctl-io - generate C interface code for libctl control files
SYNOPSIS
gen-ctl-io [OPTION]... [spec-file]
DESCRIPTION
gen-ctl-io generates C code to import/export the input/output variables used in a libctl control file. gen-ctl-io generates files like
ctl-io.h and ctl-io.c. These files define global variables, data structures, and functions for the input/output variables, classes, and
function interfaces defined in the spec-file argument, automating the interaction between C and Guile.
The arguments such as --code and --header are used to control whether ctl-io.c or ctl-io.h, etcetera, are generated. If no argument is
specified then both of these files are generated by default, for backwards compatibility.
libctl is a free library to aid in interfacing scientific software with the GNU Guile scripting and extension language. Documentation for
it may be found online at the libctl home page: http://ab-initio.mit.edu/libctl
OPTIONS
--code Generate C (or C++) source code to implement the Guile interface functions. The default output file name is ctl-io.c (in C) or ctl-
io.cpp (in C++).
--header
Generate the header file declaring the interface data types and functions. The default output file name is ctl-io.h (in C) or ctl-
io.hpp (in C++).
--swig Generate a SWIG interface definition file declaring automatic conversions for the various libctl data types. The default output
file name is ctl-io.i.
--cxx Generate C++ code instead of C code.
-o file
Use file as the output file name instead of the defaults (above).
BUGS
Send bug reports to S. G. Johnson, stevenj@alum.mit.edu.
AUTHORS
Written by Steven G. Johnson.
libctl March 27, 2006 GEN-CTL-IO(1)