Re: insert query problem

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