Is possible load into nested table by SQL*Loader?

From: Je Won Yeon <jwyeon_at_comeng.chungnam.ac.kr>
Date: Tue, 15 Sep 1998 10:58:03 +0900
Message-ID: <6tkhbq$kl5$1_at_news.chungnam.ac.kr>

I want use SQL*Loader to insert data,
and
i defined some table in nested table.

Is it possible to load SQL*Loader( Oracle Enterprise 8 version ) into nested table?

and how to describe that? ( control file, data file )

---

ex> this is my table definition

CREATE TYPE O_Attribute AS OBJECT (
 AttributeName VARCHAR2(100),
 AttributeValue VARCHAR2(100)
 );

CREATE TYPE Attributes AS TABLE OF O_Attribute;

CREATE TABLE NT_00000 (

   DocID           NUMBER(7),
   TypeID          NUMBER(3),

   Attribute_List Attributes
 )
 NESTED TABLE Attribute_List STORE AS AT_play;

=> I want to insert into nt_00000 by SQL*Loader!!!

---

thanks. Received on Tue Sep 15 1998 - 03:58:03 CEST