My Oracle Support Banner

Sql*Loader-350 Specifying Partition with Sorted Indexes (Doc ID 342058.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or built-in schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

 Receiving error SQL*LOADER-350 error trying to load data into partitioned table with sorted indexes specified.

Control Parameters:

load data
infile *
discardfile 'bill_load.dsc'
append
into table bill.image_par
sorted indexes (pk_image_par)
partition (bill_200512_data)
evaluate check_constraints reenable disabled_constraints
fields terminated by ',' optionally enclosed by '"'
(
account_id char(8),
invoice_date date "mm-dd-yyyy",
region char(2),
lob_file filler char(80),
bill_image_pdf lobfile(lob_file) terminated by EOF
)
BEGINDATA
2222222,12-02-2005,NS,"/export/home/oracle01/2222222_020205.pdf"
3333333,12-02-2005,NS,"/export/home/oracle01/3333333_020205.pdf"



> />>

 

SQL*Loader: Release 9.2.0.1.0 - Production on Mon Nov 21 09:36:25 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL*Loader-350: Syntax error at line 6.
Expecting "(", found keyword sorted.
sorted indexes (pk_image_par)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.