help getting records loaded from sqlldr log


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting help getting records loaded from sqlldr log
# 1  
Old 07-28-2005
help getting records loaded from sqlldr log

Does anyone have the code to look in a slqldr log file and get the total amount of records loaded? If so, could you please post.

Thanks much.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Number of rows loaded via sqlldr

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

SQLLDR :Data not loaded completely

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

Shell con sqlldr

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

How to get total records loaded from sqlldr log file

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

Insert value to ORACLE table from sqlldr log

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

sqlldr end of file

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

Rsh & Sqlldr

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

how to know sqlldr error?

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

value too large for column : sqlldr

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

sqlldr help

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
Login or Register to Ask a Question
vxcmdlog(1M)															      vxcmdlog(1M)

NAME
vxcmdlog - administer command logging SYNOPSIS
vxcmdlog [-H] [-l] [-m {on|off}] [-n number] [-s size] DESCRIPTION
The vxcmdlog command is used to administer command logging in Veritas Volume Manager (VxVM). This feature can be used to record all VxVM commands that are issued, and can be used in conjunction with the transaction logging feature (see vxtranslog(1M)). When the current log file reaches a maximum size, it is renamed as a historic log file, and a new current log file is created. A limited number of historic log files is preserved to avoid filling up the file system. Each log file contains a header that records the host name, host ID, and the date and time that the log was created. See the EXAMPLES sec- tion below for a description of the entries that are recorded in a log file. OPTIONS
-H Displays detailed help about the usage of the command. -l Lists current settings for command logging. This shows whether command logging is enabled, the maximum number of historic log files, and the maximum log file size. -m {on|off} Turns command logging on or off. By default, command logging is turned on. -n number Sets the maximum number of historic log files to maintain. The default number is 5. If number is set to no_limit, there is no limit on the number of historic log files that are created. -s size Sets the maximum size to which a command log can grow. (Note that this setting has no effect on existing historic log files.) The suffix modifiers k, m, and g may be used express sizes in kilobytes, megabytes and gigabytes respectively. If no suffix is specified, the default units are kilobytes. If size is set to no_limit, there is no limit on the size of the log file. The size of the command log is checked after an entry has been written so the actual size may be slightly larger than that speci- fied. When the log reaches the specified size, the current command log file, cmdlog, is renamed as the next available historic log file, cmdlog.number, where number is an integer from 1 up to the maximum number of historic log files that is currently defined. If the maximum number of historic log files has been reached, the oldest historic log file is removed, and the current log file is renamed as that file. The default maximum size of the command log file is 1m(1MB). EXAMPLES
Turn on command logging: vxcmdlog -m on Set the maximum command log file size to 512KB: vxcmdlog -s 512k Set the maximum number of historic command log files to 10: vxcmdlog -n 10 The following are sample entries from a command log file: /usr/sbin/vxdctl mode /usr/sbin/vxdisk -q -o alldgs list /etc/vx/diag.d/vxprivutil dumpconfig /dev/vx/rdmp/Disk_4s2 /usr/sbin/vxdisk list SENA0_1 Each entry usually contains a client ID that identifies the command connection to the vxconfigd daemon, the process ID of the command, a time stamp, and the command that was used together with its arguments. If the client ID is 0, as in the third entry shown here, this means that the command did not open a connection to vxconfigd. Note: The client ID is the same as that recorded for the corresponding transactions in the transactions log. FILES
/etc/vx/log Symbolic link to the log directory. This can be redefined if necessary. /etc/vx/log/cmdlog Current command log. /etc/vx/log/cmdlog.number Historic command logs. NOTES
If vxcmdlog records the invocation of a vxmake command that reads object definitions from a description file, vxcmdlog additionally records the contents of the description file. Most command scripts are not logged, but the command binaries that they call are logged. Exceptions are the vxdisksetup, vxinstall, and vxdiskunsetup scripts, which are logged. SEE ALSO
vxtranslog(1M) Veritas Volume Manager Troubleshooting Guide VxVM 5.0.31.1 24 Mar 2008 vxcmdlog(1M)