RE: import

I would use the external table like others have mentioned.

But, you could look into the 'insert all' or the 'insert first' command that is new in 9i. These commands allow you to insert into multiple tables from a single sql command:

INSERT ALL
WHEN condition_a THEN
INTO table_name_1
INTO table_name_2 (attrib1, attrib2)
VALUES (value_1, value_2)
WHEN condition_b THEN
INTO table_name_3
ELSE
INTO table_name_4
SELECT value_1, value_2, value_3
FROM table_name_0
WHERE filter_condition_0;

Or

INSERT FIRST
WHEN condition_a THEN
INTO table_name_1
INTO table_name_2 (attrib_1, attrib_2)
VALUES (value_1, value_2);

Steve Smith
Envision Technology Partners / MSHA MSIS Team Desk: 303-231-5499

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: Thursday, March 23, 2006 9:14 AM
To: howard.latham_at_rsmb.co.uk
Cc: md_at_evoconcept.de; oracle-l_at_freelists.org Subject: Re: import

or create an external table and write a plsql block.

Raj

On 3/23/06, Howard Latham <howard.latham_at_rsmb.co.uk> wrote:
> Try sqlloader.
>
> Howard A. Latham
>

Raj

--
----------------------------------------------
Got RAC?
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l