Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to insert values?

Re: How to insert values?

From: Me <me_at_privacy.net>
Date: Mon, 19 May 2003 03:08:43 +0530
Message-ID: <aavfcv8f4qb7kkg36rba6i26v2cdhoclvm@4ax.com>


On Sun, 18 May 2003 13:23:38 -0700, Ana C. Dent wrote:
:The "obvious"(?) solution is to.....
:
:DISABLE the primary & foreign keys.
:Load the data into the tables.
:ENABLE the primary & foreign keys.

Yes, that is an obvious solution. I infact used an 'obvious solution' even when I had problems creating the tables because each one had a foreign key!

But is there a 'more correct' or 'elegant' solution to

  1. Creating the tables
  2. Inserting the values (with foreign and primary keys enabled)

Thanks.

-- 
Good night
Received on Sun May 18 2003 - 16:38:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US