Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> External Table, Load string greather than 2000 char.
pierrev6378
post Mar 2 2017, 03:35 PM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 2-March 17
Member No.: 51,814



Hi,

Is someone found a workaround to load a field that is greater than 2000 char.

My csv file is comma delimited, and there is one string field as over 3000 char.

I'm getting the error KUP-04026 that is field too long...


create table ...
(
REASON VARCHAR2(4000)
)
ORGANIZATION EXTERNAL
(
REASON CHAR(2000)
)

Any Idea ?

Thanks,
Pierre
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd August 2017 - 12:15 AM