how to move table with geometry datatype ?

   Hi,

It the first time I meet this datatype. And, I'm lost. I try to manipulate it like a lob but it's not the solution.

I would like to move the table to an another tablespace.

Have you already move this ?

below my attempts :

16:01:13 SQL> alter table AR.HZ_GEOGRAPHIES move lob("GEOMETRY"."SDO_ORDINATES") store as (tabespace ARD);
alter table AR.HZ_GEOGRAPHIES move lob("GEOMETRY"."SDO_ORDINATES") store as (tablespace ARD)
                                       *
ERROR at line 1:
ORA-22917: use VARRAY to define the storage clause for this column or attribute

Elapsed: 00:00:00.01
16:51:12 SQL> alter table AR.HZ_GEOGRAPHIES move lob("SDO_ORDINATES") store as (tablespace ARD