Just for information
I've seen this too on some 8.1.7 versions on NT -
and not just on large inserts. I haven't pursued
it, though, and it doesn't seem to happen on 9.0
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminars
UK July / Sept
Australia August
Malaysia September
USA (MI) November
http://www.jlcomp.demon.co.uk/seminar.html
Marc Blum wrote in message ...
>Hi
>
>Ora EE 8.1.7.3 on SuSE Linux 7.0
>
>to reduce the content of some tables for development databases, we do that:
>
>...
>
>CREATE GLOBAL TEMPORARY TABLE my_gtt
>ON COMMIT PRESERVE ROWS
>AS
>SELECT *
>FROM my_table
>WHERE <some_conditions are true>
>
><TRUNCATE TABLE my_table>
>
><DISABLE ALL CONSTRAINTS ON my_table>
>
><DISABLE ALL TRIGGERS ON my_table>
>
><SET ALL INDEXES ON my_table TO UNUSABLE>
>
>ALTER TABLE my_table NOLOGGING;
>
>INSERT /*+ APPEND */
>INTO my_table
>SELECT * FROM my_gtt
>
><ENABLE AND REBUILD ALL THE STUFF ABOVE>
>
>
>This works really good for most tables, but the biggest one, 1.200.000 rows
with
>500 Byte each row, which is reduced to 10%, forces an end-of-communication
>error, AKA "the server process dies".
>
>Any ideas?
>
>Thanx for any help in advance.
>
>
>Marc Blum
>mailto:marc_at_marcblum.de
>http://www.marcblum.de
Received on Sat Jul 13 2002 - 04:01:56 CDT
