Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problems loading multilingual data using SQL*Loader with External Tables ...

Re: problems loading multilingual data using SQL*Loader with External Tables ...

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 28 Apr 2005 17:07:59 +0200
Message-ID: <d4qu14$qmf$1@news5.zwoll1.ov.home.nl>


  Fields in Data Source:
>
> UPDATE_FLAG CHAR (255)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> EXT_ENTID CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> EXT_INDID CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> NAME_LAST CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> NAME_FIRST CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> TITLE CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> PREFIX CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> SUFFIX CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> ENTRY_TYPE CHAR (255)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> POSITIONS CHAR (800)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> CATEGORY CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> DATE_OF_BIRTH CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> PLACE_OF_BIRTH CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> COUNTRY CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> SANCTIONS_PROGRAM CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> EXPIRATION_DATE CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> PICTURE CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> DECEASED_DATE CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> WEB_LINK CHAR (2000)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> VESSEL_CALL_SIGN CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> VESSEL_TYPE CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> VESSEL_TONNAGE CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> VESSEL_TONNAGE_GROSS CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> VESSEL_FLAG CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> VESSEL_OWNER CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> REMARKS CHAR (4000)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> LANGUAGE_ISO_CODE CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> ENTERED_DATE CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> ENTERED_BY CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> LAST_UPDATE CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
> LAST_UPDATE_BY CHAR (500)
> Terminated by "|"
> Trim whitespace same as SQL Loader
>
> ********************************
>

That's an extremely long record...

-- 
Regards,
Frank van Bortel
Received on Thu Apr 28 2005 - 10:07:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US