Sponsored Content
Full Discussion: Load error
Top Forums UNIX for Dummies Questions & Answers Load error Post 66171 by musavir19 on Friday 11th of March 2005 07:00:10 AM
Old 03-11-2005
Load error

hi

i am facing a problem when i run a shell script to load a table.the error is

Record 1: Rejected - Error on table TRENDS."SHP_CUST_ORD_ITM".
ORA-14400: inserted partition key is beyond highest legal partition key

Record 2: Rejected - Error on table TRENDS."SHP_CUST_ORD_ITM", column PROD_NBR.
ORA-01722: invalid number
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table TRENDS."SHP_CUST_ORD_ITM":
0 Rows successfully loaded.
2 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


Space allocated for bind array: 51968 bytes(64 rows)
Space allocated for memory besides bind array: 0 bytes

Total logical records skipped: 0
Total logical records read: 6
Total logical records rejected: 2
Total logical records discarded: 0

Run began on Fri Mar 11 03:25:15 2005
Run ended on Fri Mar 11 03:25:18 2005

Elapsed time was: 00:00:02.73
CPU time was: 00:00:00.45

please help
thnx in advance
 

9 More Discussions You Might Find Interesting

1. Linux

load error while creating shared library

Hi, I am trying to create shared library. When i run the script to build the library i get these errors ld: warning: option -o appears more than once, first setting taken ld: fatal: file libgc.so.0: open failed: No such file or directory ld: fatal: File processing errors. No output written... (0 Replies)
Discussion started by: masg1
0 Replies

2. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

hi all need your help. I am wrting a script that will load data into the table. then on another load will append the data into the existing table. Regards Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies

3. UNIX for Advanced & Expert Users

sql load error in unix

When i try to run a job in unix, i am getting sqlload error as, sqlload : file not found. Can any one please let me know whats the reason for this.. The PATH & ORACLE_HOME paths names are correct... thanks here is the script : plz hv a look TABLE_NAME= tablename... (1 Reply)
Discussion started by: abhi_123
1 Replies

4. UNIX Desktop Questions & Answers

gtk2-perl load error help

I write this code. It show the first dialog correctly. but, no matter i modify the code(load module by use or require, or something i think maybe error) it can't pop-up anymore. and show this warning. Thanks. (I'm sorry for my English.) Tue Mar 16 17:24:36 2010 ... (0 Replies)
Discussion started by: snyh
0 Replies

5. Shell Programming and Scripting

Stop load script if error found...

Hi all, Is there any command in Unix, which will stop the load process if any error is found in the i/p file? I am trying to load 5 files sequentially. A then B then C then D then E end; 1) If A encounter's any error while data load, the load process should stop, and it should not... (5 Replies)
Discussion started by: msrahman
5 Replies

6. Windows & DOS: Issues & Discussions

Perl2exe Error Can't Load MacPerl.pm

Hi all, I am new to perl and have finished writing my first script. The script runs well on my machine and now I want to translate it to an executable to distribute with clients. I am running ActivePerl 5.8.9 Build 829 and Perl2exe V10.10 I keep getting the error Warning: Can't locate... (0 Replies)
Discussion started by: chazchaz
0 Replies

7. UNIX for Dummies Questions & Answers

VPS has load 200, httpd load no activity, netstat nothing

Hello, on my hostserver i see one VPS of mine got load of 200.00 and netstat nothing (not a single blank line on netstat command) after some time, netstat started showing connections, but i see no excessive IP connections. tail -f /var/log/httpd/access_log shows no activity /var/log/messages ;... (1 Reply)
Discussion started by: postcd
1 Replies

8. SCO

FATAL BOOT ERROR: Can’t load stage 3

I'm under huge pressure to recover data from an old server that only gets booted very infrequently. The data on it is urgently required - isn't always??! .. Server is an HP DL380G5 which is running SCO Unixware 7.11 .. It has 3 partitions in a RAID 5 Configuration: 1 of 10GB (I assume it... (19 Replies)
Discussion started by: BernP
19 Replies

9. Solaris

Pam_UNIX_cred: cannot load ttyname Error 0

We received a VM running Solaris 10 After reconfiguring network interfaces to get it on our network, we're getting "pam_unix_cred: cannot load ttyname Error 0" when any accountt ries to log in at the console. I can ssh in just fine. Googling suggests this may have something to do with Trusted... (2 Replies)
Discussion started by: jnojr
2 Replies
WREN(3) 						     Library Functions Manual							   WREN(3)

NAME
wren, ata - hard disk interface SYNOPSIS
bind #H[drive] /dev bind #w[target[.lun]] /dev /dev/hd0disk /dev/hd0partition /dev/sd0disk /dev/sd0partition ... DESCRIPTION
The hard disk interfaces (wren, #w, is a SCSI disk; ata, #H, is an IDE or ATA disk) serve a one-level directory giving access to the hard disk partitions. The parameter to attach defines the numerical SCSI target and logical unit number or the IDE drive number to access. Both default to zero. Each partition name is prefixed by hd and the numeric drive identifier. The partition always exists and covers the entire disk. The size of each partition as reported by stat(2) is the number of bytes in the partition, so the size of is the size of the entire disk. The partition also always exists; it is the last block on the disk for SCSI, second to last for IDE. If it contains valid partition data, those partitions will be visible as well. Every time the device is bound, the partitions are updated to reflect any changes in the parti- tion file. The format of the partition file is the string plan9 partitions on a line, followed by partition specifications, one per line, consisting of a name and textual strings for the block start and limit for each partition on the disk. The program prep(8) writes the partition table for the disk; its use is preferred to writing it by hand. SEE ALSO
prep(8), scsi(3) SOURCE
/sys/src/9/port/devwren.c /sys/src/9/pc/devata.c WREN(3)
All times are GMT -4. The time now is 09:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy