Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Loader only loads first row into nested table
On 06.09.2005 16:03 Maxim Demenko wrote:
> The following control file should work with your data.
>
> options (skip=1)
> LOAD DATA CHARACTERSET UTF8
> TRUNCATE
> INTO TABLE user_profile
> FIELDS TERMINATED BY '|'
> TRAILING NULLCOLS
> (
> userid,
> lastname,
> firstname,
> usergroups NESTED TABLE terminated by '|'
> (group_name CHAR terminated by ';')
> ,
> flag char(1) TERMINATED BY WHITESPACE
> )
>
>
> Best regards
>
> Maxim
Brilliant. Works like a charm.
Thanks a bunch
Thomas
Received on Tue Sep 06 2005 - 09:13:26 CDT