12-27-2006
use sqlldr
what database you are using?
use sqlldr.
Eg:
LOAD DATA INFILE * APPEND INTO TABLE <<Tablename>> FIELDS TERMINATED BY "," TRAILING NULLCOLS
(<<fieldname>> INTEGER EXTERNAL)
make it as file.ctl
and then use sqlldr like this
${ORACLE_HOME}/bin/sqlldr userid=${USERPASS} control=<<path>>/file.ctl log=<<path>>/<<filename>>.log data=<<path>>/<<20000filename>> errors=1000 &
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Guys,
I want to insert some values from a log file into a temporary table. the values in the log file looks like this
SV_NAME CC_NAME CP_DISP_RUN_STATE
------- ------------------- -----------------
sble01 ALLTEL WorkMon24Hrs Running
I want to enter the... (2 Replies)
Discussion started by: ragha81
2 Replies
2. Shell Programming and Scripting
Hi gurus, hoping someone can help with a sed line that can do the following...
I have a flat file with about 1000 records, but in order to import into openoffice spreadsheet, I need to create a delimited file. I'd like to do 2 things with the SED command:
1- add a pipe character "|" at the end... (4 Replies)
Discussion started by: RogCor
4 Replies
3. Shell Programming and Scripting
Hi all,
I am using this command "sort -d -u -k1 IMSTEST.74E -o tmp.txt" to the records in the flat.
Can any tell me how to sort the file except first line in the file
For ex:
i/p
First line: DXYZ
Second line : jumy
third : cmhk
fourth : andy
Output should... (5 Replies)
Discussion started by: sudhir_barker
5 Replies
4. Shell Programming and Scripting
Hi,
I want to insert data into a table from a flat file, the file is having around 25 columns and some 10,000 records.
The columns values are seperated by a space.
Thanks (1 Reply)
Discussion started by: ss_ss
1 Replies
5. Shell Programming and Scripting
Hi All,
I need to load records from oracle table XYZ to a flat file say ABC.dat.
could any one tell me how do i do this in UNXI,
Regards
Ann (1 Reply)
Discussion started by: Haque123
1 Replies
6. Shell Programming and Scripting
Hi all,
I need to know how to copy data from a table say ABC to a flat file say XYZ.dat in unix,
Please leave ur comments and the fastest way to do so,
I need to load the table records into flat file.
Regards
Ann (4 Replies)
Discussion started by: Haque123
4 Replies
7. Shell Programming and Scripting
I have a flat file that contains records similar to the following two lines;
1984/11/08 7 700000 123456789 2
1984/11/08 1941/05/19 7 700000 123456789 2
The 123456789 2 represents an account number, this is how I identify the duplicate record.
The ### signs represent... (4 Replies)
Discussion started by: jolney
4 Replies
8. UNIX for Dummies Questions & Answers
I have a csv flatfile with a few million rows. I need to replace a field (field number is 85) in the file with a sequential number.
As an example, let's assume there are only 4 fields in the file:
A,A,,32
A,A,,27
A,B,,43
C,C,,354
If I wanted to amend the 3rd field in this way my... (2 Replies)
Discussion started by: BristolSmithy
2 Replies
9. Shell Programming and Scripting
Hi All,
I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far.
1. Table.txt ==> database extract file
2. flat.txt ==> pipe delimited after some manipulation of the original db... (0 Replies)
Discussion started by: express14
0 Replies
10. Shell Programming and Scripting
Hi all,
I am reading control file log from my server and putting it to a variable
for j in $(cat $dirname/ctl_file.log)
do
if
then
Y=${#fileclob_ctl_file}
if
then
fileclob_ctl_file=$j
else
fileclob_ctl_file="${fileclob_ctl_file},${j}"
fi
fi
... (5 Replies)
Discussion started by: Pratiksha Mehra
5 Replies
LEARN ABOUT DEBIAN
uucpsend
uucpsend(8) Programmer's Manual uucpsend(8)
NAME
uucpsend - Alternative frontend for uucp batching
SYNOPSYS
uucpsend [ -c config ] [ -f appendix ] sitename [ sitename ... ]
This program offers a comfortable way to do news batching with the INN news system. Like the name assumes it is used for sites that are
connected via UUCP. The idea behind the mechanism is taken from the nntpsend program which is already included in distributions of INN.
The program does not do the batching itself. Instead it lets commonly used tools do the work. However it controls their behaviour. Using
uucpsend you can define detailed how batching for each site shall take place in an easy fashion.
In the file uucpsend.ctl(5) for each site your server feeds you can specify the size of batches, the maximal disk space that may be used by
the uucp site, the header that should be written in the batch (e.g. funbatch, cunbatch, gunbatch etc.), the compression program to use as
well as additional arguments passed to uux(8).
The sitename should be the name of the site as specified in the newsfeeds(5) file. If no sitenames are passed to the program it will loop
over all sites that described in the configuration file. This makes it easy to maintain sets of sites that are to be batched one after the
other - contrary to batching through the whole day.
A batcher(8) is launched for sites with queued news. Output is sent to the file /var/log/news/uucpsend.log. In order to keep from over-
whelming the local system, uucpsend waits five seconds before the next site is fed. Uucpsend expects that the batchfile for a site is
named /var/spool/news/out.going/sitename. To prevent batchfile corruption, shlock(1) is used to ``lock'' these files.
It is useful to have cron(8) invoke uucpsend.
When no sites are given on the command line, any flags given on the command completely describe how batcher operate. When no sites are
given on the command line, then the information found in uucpsend.ctl becomes the default flags for that sites.
OPTIONS
-f config
Using this parameter you are able to specify a file different to PATH_UUCPCTL which defaults to /etc/news/uucpsend.ctl.
-f appendix
With the parameter ``-f'' you may specify another uucpsend.ctl(5) file. Information with regard to also given sitenames are read
from the uucpsend.ctl-file. Please keep in mind that all default values are still read from the main uucpsend.ctl file. This fea-
ture has been added to let big sites easily specify a different batching behaviour.
HISTORY
Written by Martin Schulze <joey@infodrom.org>, derived mostly from nntpsend(8) by Landon Curt Noll <chongo@toad.com> and Rich $alz
<rsalz@uunet.uu.net> for InterNetNews.
SEE ALSO
innxmit(1), newsfeeds(5), uucpsend.ctl(5), nntppsend(8), nntppsend.ctl(5), shrinkfile(1).
Infodrom 21 November 2001 uucpsend(8)