07-26-2011
Problem with control file and special character
I am getting error when loading data file using ctl file. I get this error only when there is special character.
Below is some data.
DataFile=>
company_id|ciu_id|english_name|iso_country_code|active|partner_name
1-2JT-122||Expert Järvenpää|FI|A|Expert Järvenpää
Control File=>
LOAD DATA
CHARACTERSET UTF8
APPEND INTO TABLE MyTable
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
COMPANY_ID,
CIU_ID,
ENGLISH_NAME,
ISO_COUNTRY_CODE,
ACTIVE,
ACTIVE_PARTNER_NAME,
)
Error=>
Record 1: Rejected - Error on table “MyTable”, column ACTIVE.
ORA-12899: value too large for column " MyTable"."ACTIVE" (actual: 25, maximum: 4)
10 More Discussions You Might Find Interesting
1. Solaris
Hi together
I have 2 systems, mars and venus. The configuration is the same. Every system has a SDLT. I will now backup the datas from mars on the tapedevice from venus.
I have shareed the tapedevice (venus) and mounted on mars.
Now my problem: when I write on the mountet tapedevice, the... (1 Reply)
Discussion started by: MuellerUrs
1 Replies
2. UNIX for Dummies Questions & Answers
I'm having problems deleting a file with a special character and I'm hoping that somebody here can help. The file "-osample1.c" will not remove from my directory. Here is an example of what happens. Any ideas would be appreciated.
> ls *sample1*
ls: illegal option -- .
usage: ls... (2 Replies)
Discussion started by: hart1165
2 Replies
3. Shell Programming and Scripting
hi
i want to delete a particular character in file.
example
file name:abcsample
abc=bbbqw3/
hidh=ajjqiwio4/
xyx=hakjp/
........../
......./
i want to delete that special character (/) in abcsample file.please give the required commands for my requirement.
thank you (3 Replies)
Discussion started by: srivsn
3 Replies
4. Shell Programming and Scripting
hi
i want to delete a particular character in file.
example
file name:abcsample
abc=bbbqw3/
hidh=ajjqiwio4/
xyx=hakjp/
........../
......./
i want to delete that special character (/) in abcsample file Permnently.please give the required commands for my requirement.
required... (1 Reply)
Discussion started by: srivsn
1 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I am looking for a solution to capture any ASCII control character in a file
( where the ASCII control character is in decimal value from 0 to 31 and 127
( Hex value from 00 to 1F and 7F ) ) by returning any affected lines.
The intended good file should contain "ASCII printable... (5 Replies)
Discussion started by: cursive
5 Replies
6. UNIX for Dummies Questions & Answers
I have a special character in my file. It displays as a '#' sign but when I do this command I do not find the line.
fgrep 'G#ant' file1
I want to replace the special character with another value but I need to know what character it really is. Any ideas on how to replace this '#' value with... (3 Replies)
Discussion started by: Ryan2786
3 Replies
7. Shell Programming and Scripting
Hi,
My file has this special character "^M"
I would like to remove this characters.
eg:
abc,abc,^M
i tried using sed but doesnt work.
i used octal dump command to see special character it returns following:
015
\r
Appreciate your reply. (6 Replies)
Discussion started by: pinnacle
6 Replies
8. Shell Programming and Scripting
in a file we are getting control character in a file , is there any way that they can be removed once we have the file
for eg.
BEGIN-PROCEDURE INITIALIZE
^M
LET #row_count = 0^M
^M
^M (2 Replies)
Discussion started by: lalitpct
2 Replies
9. Red Hat
All,
I am having a tough time with Linux and CSV file. My CSV file gets generated from Cognos on Linux machine that contains special characters. At first instance when I do vi <filename> to that file, I can't see anything. I did tail -2 and redirected to another temp file and did vi <filename>,... (2 Replies)
Discussion started by: donadarsh
2 Replies
10. Red Hat
Hi Guys,
We receive some huge files on to Linux server. Source system use FTP mechanism to transfer these files on our server. Occasionally one record is getting corrupted while transfer, some control characters are injecting into the file. How to fix this issue ? please advice ?
Sample... (2 Replies)
Discussion started by: srikanth38
2 Replies
LEARN ABOUT REDHAT
mod-active
MOD-ACTIVE(8) System Manager's Manual MOD-ACTIVE(8)
NAME
mod-active - batch processing of ctlinnd newgroup/rmgroup/changegroup
SYNOPSIS
mod-active [ ctlinnd_command_file ]
DESCRIPTION
mod-active is a perl script that updates the active file based on its input lines of ctlinnd newgroup, rmgroup and changegroup commands.
It pauses the server briefly while the existing active file is read and rewritten, which not only keeps innd from updating the active file
but also locks against other instances of mod-active.
The input to mod-active can come either from one or more files named on the command line, or from the standard input. Typically its input
is the output from the docheckgroups or actsync commands. Every line which contains the string "ctlinnd newgroup", "ctlinnd rmgroup" or
"ctlinnd changegroup", optionally preceded by whitespace and/or the path to ctlinnd, is noted for the update. Redundant commands, such as
a newgroup directive for a group that already exists, are silently ignored. All other lines in the input are also silently ignored.
After the new active file has been generated, the existing one is renamed to active.old and the new one is moved into place. The script
then displays the differences between the two files.
Any groups that were added to the active file are also added to the active.times file with the string "checkgroups-update".
BUGS
Though innd is paused while mod-active works, it is not inconceivable that there could be a conflict if something else tries to update the
active file during the relatively short time that mod-active is working. The two most realistic ways I can think of for this to happen are
either by an administrator concurrently doing a manual ctlinnd command, or by innd receiving a control message, then mod-active pausing the
server, then the control message handler script that innd forked running its own ctlinnd command while mod-active is working. I've been
using mod-active regularly for several years, though, and never had either problem.
HISTORY
Written by David C Lawrence <tale@isc.org>.
SEE ALSO
active(5), actsync(8), ctlinnd(8), innd(8).
MOD-ACTIVE(8)