Visit Our UNIX and Linux User Community


SQLLDR file not able to modify in Linux


 
Thread Tools Search this Thread
Operating Systems Linux SQLLDR file not able to modify in Linux
# 1  
Old 03-07-2014
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
Code:
 
"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

Last edited by vbe; 03-07-2014 at 12:01 PM.. Reason: rm color + added code tags
# 2  
Old 03-07-2014
The answer I suppose is what I see in the error message:add ! to override

Previous Thread | Next Thread
Test Your Knowledge in Computers #350
Difficulty: Medium
AWK was originally written in 1975 and distributed with Version 6 Unix.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to create the SQLLDR control file from Oracle table.

I need to create the shell script load the few 100 table using the SQLLDR. Need to generate the control file for each table using oracle table. table has "table names" and "column names" using this need create the control file. example table rows below table_nme column_nme DEPT ... (2 Replies)
Discussion started by: pimmit22043
2 Replies

2. Shell Programming and Scripting

Modify a file by another file: add new line and variable after string is found

hello, I have problem with writing/adjusting a shell script. I searched forum and unfortunately couldn't write scipt based on the information I found. I never wtire such so it's hard for me and I do need to modify one script immediately. case looks like: 1. 'file' that needs to be modified... (3 Replies)
Discussion started by: bipbip
3 Replies

3. Shell Programming and Scripting

Modify awk command to work in linux

Hi All I have the original file like '1','3','COMMON','N','djpCM3PopDimDateGen','JobDescription','1','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDim1','JobDescription','2','ds','O','ONE' '1','3','COMMON','N','djpCM3PopDim2','JobDescription','3','ds','O','ONE'... (3 Replies)
Discussion started by: vee_789
3 Replies

4. Programming

How to modify all Makefiles in a source tree into linux environment

Hi Frndz, I am new to the makefile generation. I have a source code which contains makefiles in each sub-directories. Previously we have used the entire source code in Dtbuild environment to get the executables. Now have to change the current Dtbuild environment to Linux build... (1 Reply)
Discussion started by: korraag
1 Replies

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

6. Programming

How to modify this c code to get full GUI interface for Unix Linux ?

Hi, the following code comes from Unix Linux dialog utility project. Unfortunately, this project is no more actively maintained. Unix Linux dialog utility is made of widget boxes. One of them is mixedgauge.c In the following example I would like to get rid of flickering when run in... (0 Replies)
Discussion started by: jack2
0 Replies

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

8. Shell Programming and Scripting

Can I modify the .bashrc file instead of .profile file to customize my login?

Hello, I got this question which tells me to customize my login script. Some people in the forums suggested to modify the .profile file in my home directory. I did so, but none of my customizations show up when I open the terminal after. So, I tried to modify other files in my home directory,... (1 Reply)
Discussion started by: Hyunkel
1 Replies

9. Shell Programming and Scripting

Pass tablename as a parameter in the Control File -- sqlldr

Just wanted to know if there is a way to pass the table name as a parameter in the control file. I have two tables...Table A and Table B. LOAD DATA append INTO TABLE TABLE_B FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' AND '"' TRAILING NULLCOLS Rather than hard coding... (1 Reply)
Discussion started by: madhunk
1 Replies

10. UNIX for Dummies Questions & Answers

Modify semaphores parameters on Linux

Hello, I need to modify the semaphores parameters on a Linux server Debian 2.2.R3. How can I do it? Thks. (6 Replies)
Discussion started by: annececile
6 Replies

Featured Tech Videos