Sponsored Content
Full Discussion: sqlldr help
Top Forums Shell Programming and Scripting sqlldr help Post 302118796 by Unbeliever on Thursday 24th of May 2007 08:54:31 AM
Old 05-24-2007
Check the manual for your shell for the 'read' command. If you need to turn off echoing of characters when the user puts in the password it can be turned off and on using the 'stty' command.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. Shell Programming and Scripting

sqlldr in shell script

Hi I'm using SQL*Loader in shell script as below sqlldr $uname/$pword@$ORACLE_SID parfile=$test.par for e.g. if $test is 'file1' and getting the below error LRM-00109: could not open parameter file 'file1' LRM-00113: error when processing file 'file1' SQL*Loader: Release... (7 Replies)
Discussion started by: vinoth_kumar
7 Replies

7. Linux

SQLLDR file not able to modify in Linux

Hi All I am trying to modifying SQLLDR file in Linux, I’m getting the below error "counterparty.sqlldr" E506: Can't write to backup file (add ! to override) Press ENTER or type command to continue Can someone help me resove this issue. Thank (1 Reply)
Discussion started by: na.dharma
1 Replies

8. Shell Programming and Scripting

Parallel sqlldr to load data.

I am using SQLLDR to load data in DB.For parallel loading I'm using nohup command. The requirement is: I have different files within a directories. Ex: 1) Dir/folder_A/AE.txt 2) Dir/folder_A/DM.txt 3) Dir/folder_B/CM.txt I need to loop through directories and load the data... (1 Reply)
Discussion started by: Pratiksha Mehra
1 Replies

9. 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

10. 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
SIEVESHELL(1)						User Contributed Perl Documentation					     SIEVESHELL(1)

NAME
sieveshell - remotely manipulate sieve scripts SYNOPSIS
sieveshell [--user=user] [--authname=authname] [--realm=realm] [--password=password] [--exec=script] [--execfile=file] server[:port] sieveshell --help DESCRIPTION
sieveshell allows users to manipulate their scripts on a remote server. It works via MANAGESIEVE, a work in progress. The following commands are recognized: list list scripts on server. put <filename> upload script to server. get <name> [<filename>] get script. if no filename display to stdout delete <name> delete script. activate <name> activate script. deactivate deactivate all scripts. OPTIONS
-u user, --user=user The authorization name to request; by default, derived from the authentication credentials. -a authname, --authname=authname The user to use for authentication (defaults to current user). -r realm, --realm=realm The realm to attempt authentication in. -p password, --password=password The password to use when authenticating to server. Note that this parameter can be seen in the process list. Use with caution! -e script, --exec=script Instead of working interactively, run commands from script, and exit when done. -f file, --execfile=file Instead of working interactively, run commands from file file and exit when done. REFERENCES
[MANAGESIEVE] Martin, T.; "A Protocol for Remotely Managing Sieve Scripts", draft-ietf-managesieve-03.txt, Mirapoint, Inc.; May 2001, work in progress. AUTHOR
Tim Martin <tmartin@mirapoint.com>, and the rest of the Cyrus team <cyrus-bugs@andrew.cmu.edu>. perl v5.14.2 2014-06-03 SIEVESHELL(1)
All times are GMT -4. The time now is 06:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy