Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problems loading multilingual data using SQL*Loader with External Tables ...
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 BortelReceived on Thu Apr 28 2005 - 10:07:59 CDT