Load error Post: 66223

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Load error Post 66223 by tmarikle on Friday 11th of March 2005 04:44:47 PM

03-11-2005

Registered User

Quote:

Originally Posted by Da_Duck

for record 1:
you have a partitioned table by date. You are attempting to load a date-value into the table that is higher than your highest dated-partition.

example:
My table partitions highest value is March 12, 2005
If I attempt to enter a date larger than March 11, 2005 I will get this error.
The partition only handles anything LESS than the date specified.

...therefore, have your DBA add a partition that either accomodates the higher range value or a partition speficying MAXVALUE to represent a virtual infinite value.

Quote:

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.

Since the two errors occurred on the same column, it is likely that the data is wrong and nonsensical with respect to the partition key. In which case, the record rejection is the correct response. These are also the first two records in the table so review the data and the sqlldr control file.

Thomas

tmarikle

View Public Profile for tmarikle

Find all posts by tmarikle

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

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

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

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

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

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

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

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

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

LEARN ABOUT MINIX

repartit

REPARTITION(8)						      System Manager's Manual						    REPARTITION(8)

NAME

       repartition - load a partition table

SYNOPSIS

       repartition device [partition-file]

DESCRIPTION

       Repartition  uploads  a new partition table for the partitions of device.  The table is obtained from the first sector of partition-file if
       given, device otherwise.  Device may refer to the whole drive or a primary partition, depending on whether you want to upload  a  partition
       or a subpartition table.  The partitions will be truncated to fit within the enclosing device like the disk driver does, unless the numbers
       are coming from partition-file.

EXAMPLES

       repartition /dev/hd0
       repartition /dev/hd4 /etc/hd4.table

       Reload the partition table of drive 0 setting /dev/hd[1-4], and the subpartition table of /dev/hd4 setting /dev/hd4[a-d] using a file.  The
       latter may be useful if you need more than the 4 subpartitions a single Minix partition gives you.

DIAGNOSTICS

       The new table is printed on standard output.

FILES

       /dev/hd[0-9]

SEE ALSO

       hd(4), part(8).

BUGS

       The disk must be in use for the changes to stick.  The partition table of an idle disk will be reloaded on the first open.

AUTHOR

       Kees J. Bot (kjb@cs.vu.nl)

																    REPARTITION(8)