Sponsored Content
Full Discussion: Load error
Top Forums UNIX for Dummies Questions & Answers Load error Post 66223 by tmarikle on Friday 11th of March 2005 04:44:47 PM
Old 03-11-2005
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
 

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
PARTITION(8)						      System Manager's Manual						      PARTITION(8)

NAME
partition - make a partition table SYNOPSIS
partition [-mf] device [type:]size[+*] ... DESCRIPTION
Partition makes a partition table on device using the types and sizes given. It may be used in combination with repartition(8) for auto- matic installation of Minix. You may give up to four type:size[+*] specifications for the partitions. You may also specify holes before, between, and after the parti- tions. A hole differs from a partition specification by not having a type. The first hole is by default 1 sector to make space for the primary bootstrap and the partition table. The other holes are 0. The type field is the type of the partitition in hexadecimal. The size field is the partition's size in sectors. The + or * may option- ally be added to indicate that the partition must be expanded to contain any leftover space on the device or to mark the partition active. Partitions are padded out to cylinder boundaries, except for the first one, it starts on track 1. Some operating systems care about this. Minix and MS-DOS do not. OPTIONS
-m Minix only, no need to pad partitions. This is the default for subpartition tables. -f Force making a partition table even if the device is too small. EXAMPLE
partition /dev/hd0 01:16384 81:40000 81:2880* 06:20000+ Partitions disk 0 into an 8 Mb DOS partition, 20 Mb Minix /usr, 1.44 Mb Minix / (active), and a DOS partition of at least 10 Mb at the end of the disk. (06:0+ would have been ok too, it's just a sanity check.) SEE ALSO
hd(4), part(8), repartition(8). AUTHOR
Kees J. Bot (kjb@cs.vu.nl) PARTITION(8)
All times are GMT -4. The time now is 07:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy