import on spatial column extremely slow

On oracle 9205,
I have a table like this:

CREATE TABLE SITE_NOS (

       SITE_ID              NUMBER(17) NULL,
       GEOLOC               MDSYS.SDO_GEOMETRY NOT NULL,
       GEOLOC_LINE          MDSYS.SDO_GEOMETRY NULL
      );

because of this two sptial columns, the import is extremely slow, could any body give me any suggestions?

Your help is highly appreciated

Charlie Received on Wed Dec 01 2004 - 21:19:50 CST