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
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
LEARN ABOUT MINIX
partitio
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)