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