10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I'm loading data in database through sqlldr.
I want to know the total record count
And the number of records inserted in table..
what is the logic to achieve that.
Thanks (5 Replies)
Discussion started by: Pratiksha Mehra
5 Replies
2. Shell Programming and Scripting
Hi ,
I am using below control file
LOAD DATA
APPEND
INTO TABLE LSHADMIN.EG
TRAILING NULLCOLS
(
STUDY CHAR
)
and the text file to load data is
CACZ885M2301
When I run below command:
sqlldr userid=apps/apps control=/home/appsuser/dataload/ctl_file.ctl... (3 Replies)
Discussion started by: Pratiksha Mehra
3 Replies
3. Shell Programming and Scripting
Hola,
Genere un proceso en proC que me inserta registros a oracle, el cual ejecuto desde un shell en Unix. Por otro lado tengo un sqlldr que me hace el trabajo en un 25 % de tiempo que mi proceso en C.
Se que puedo ejecutar mi sqlldr desde un shell, pero no se como hacer, alguien tiene un... (0 Replies)
Discussion started by: marcoinxs
0 Replies
4. Shell Programming and Scripting
Hi,
I am loading data in the database table through sqlldr. I have to find total records loaded from sqlldr log file and store it in a variable in my script. How do I get it?
Thank you. (3 Replies)
Discussion started by: mrpranab
3 Replies
5. Shell Programming and Scripting
This is the sample sqlldr log:
------------------------------------------------------------------------------------------------------------
SQL*Loader: Release 9.2.0.7.0 - Production on Sun Feb 8 23:37:02 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control... (13 Replies)
Discussion started by: aimy
13 Replies
6. Shell Programming and Scripting
Hi,
I've a batch program that load data from a file like:
00000013|FERRAN|JULIAN|GONZALEZ|1|
00000014|FRANCESC|NARVAEZ|PAZOS|1|
00000015|INMACULADA|MAYOL|BELTRAN|2|
I used the sqlldr command in this way:
sqlldr userid=U/P control=$SCRIPTS/CTRL.WCT data=$DATA/FILE log=$LOGS/FILE.LOG... (2 Replies)
Discussion started by: raippl
2 Replies
7. Shell Programming and Scripting
Dear expert,
Can we invoke sqlldr command remotely.
When I try rsh command in machine 10.1.65.116, it's failed on sqlloader command. However, nothing wrong on the shell scripts or environment setting of the remote environment, I able to execute in the scripts in remote machine.
in machine... (8 Replies)
Discussion started by: epall
8 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
Can anyone know how to get the error codes from 'sqlldr' ?While am trying to load some 'ISO-8859-1' data file into 'utf8' oracle database,some records are rejected.I want to know the reason,whether it is due to charset mismatch or some other issues.How come i to know that ?
... (3 Replies)
Discussion started by: DILEEP410
3 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I am a newbie to Linux(Suse).I am facing a problem with 'sqlldr' utility while trying to upload data to Database tables.My backend is Oracle and is using the UTF8 encoding format.I am trying to load a datafile which contains some Western European Characters.While loading am getting an error... (1 Reply)
Discussion started by: DILEEP410
1 Replies
10. Shell Programming and Scripting
1.The below script works perfectly fine in dev. However, i have been told that i cannot hardcode the password into the file during production impementation. Is their way i could ask the user to enter the password when the script is executed
2. I have seven different files each of which needs to... (1 Reply)
Discussion started by: systemsb
1 Replies
IPL(4) Kernel Interfaces Manual IPL(4)
NAME
ipl - IP packet log device
DESCRIPTION
The ipl pseudo device's purpose is to provide an easy way to gather packet headers of packets you wish to log. If a packet header is to be
logged, the entire header is logged (including any IP options - TCP/UDP options are not included when it calculates header size) or not at
all. The packet contents are also logged after the header. If the log reader is busy or otherwise unable to read log records, up to
IPLLOGSIZE (8192 is the default) bytes of data are stored.
Prepending every packet header logged is a structure containing information relevant to the packet following and why it was logged. The
structure's format is as follows:
/*
* Log structure. Each packet header logged is prepended by one of these.
* Following this in the log records read from the device will be an ipflog
* structure which is then followed by any packet data.
*/
typedef struct iplog {
u_long ipl_sec;
u_long ipl_usec;
u_int ipl_len;
u_int ipl_count;
size_t ipl_dsize;
struct iplog *ipl_next;
} iplog_t;
typedef struct ipflog {
#if (defined(NetBSD) && (NetBSD <= 1991011) && (NetBSD >= 199603))
u_char fl_ifname[IFNAMSIZ];
#else
u_int fl_unit;
u_char fl_ifname[4];
#endif
u_char fl_plen; /* extra data after hlen */
u_char fl_hlen; /* length of IP headers saved */
u_short fl_rule; /* assume never more than 64k rules, total */
u_32_t fl_flags;
} ipflog_t;
When reading from the ipl device, it is necessary to call read(2) with a buffer big enough to hold at least 1 complete log record - reading
of partial log records is not supported.
If the packet contents are more than 128 bytes when log body is used, then only 128 bytes of the packet contents are logged.
Although it is only possible to read from the ipl device, opening it for writing is required when using an ioctl which changes any kernel
data.
The ioctls which are loaded with this device can be found under ipf(4). The ioctls which are for use with logging and don't affect the
filter are:
ioctl(fd, SIOCIPFFB, int *)
ioctl(fd, FIONREAD, int *)
The SIOCIPFFB ioctl flushes the log buffer and returns the number of bytes flushed. FIONREAD returns the number of bytes currently used
for storing log data. If IPFILTER_LOG is not defined when compiling, SIOCIPFFB is not available and FIONREAD will return but not do any-
thing.
There is currently no support for non-blocking IO with this device, meaning all read operations should be considered blocking in nature (if
there is no data to read, it will sleep until some is made available).
SEE ALSO
ipf(4)
BUGS
Packet headers are dropped when the internal buffer (static size) fills.
FILES
/dev/ipl0
IPL(4)