Data load question

I need to load data from one table to two tables. It is kind of noramlizing the data.

As an example:
Source table:
Table A(col1, col2)

A1,B1
A1,B2
A2,B3
A2,B4
A3,B5

From this table I need to insert into Table B and C

I wan to insert data into B and C as:

Table B(id, col1) id is synthetic pk from sequence

1,A1
2,A2
3,A3

Table C(id, col2,B_id) id is pk, b_id is fk to B.id

1,B1,1
2,B2,1
3,B3,2
4,B4,2
5,B5,2

Source table A has 2 million rows. I am trying to do through a single select on table A and using insert into .. select. Or using FORALL.

Any good ideas on how to do this?

Regards

Sandeep

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