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: insert query problem

Re: insert query problem

From: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Tue, 30 Mar 1999 14:46:10 +0000
Message-ID: <3700D5A1.FBBF0F9D@capgemini.co.uk>


Try TRUNCATEing TABLE1 to reset the free space settings.

Peter ONeill wrote:

> INSERT INTO TABLE1
> (COL1,COL2,COL3)
> (SELECT
> COL1, COL2, COL3
> FROM TABLE2
> ORDER BY PRIMARY_KEY_COL)
>
> TABLE1 HAS A BEFORE INSERT TRIGGER THAT INSERTS PRIMARY KEY USING A
> SEQUENCE
> HOWEVER THE INSERT ORDER APPEARS TOTALLY RANDOM EVEN THOUGH I ADDED AN ORDER
> BY CLAUSE.
>
> IE TABLE 2 FIRST RECORD MIGHT BE 40TH RECORD IN TABLE 1 RATHER THAN FIRST
> RECORD.
>
> ANYONE KNOW WHAT THE PROBLEM IS?
>
> THANKS
> PETER
Received on Tue Mar 30 1999 - 08:46:10 CST

Original text of this message

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