help: User defined datatype does not work across database link

In one of our tables, we have a
column(spatial stuff)

(GEOLOC MDSYS.SDO_GEOMETRY) All the "copy", "create as select"
etc. do not work across the database
link. Everytime we want to aging a
table and move the old data to our
archive database, we would have to
create a temp table, export the temp table and ftp it to archive database and
do the import, and then do select and insert. So many steps and it is not solid, not
easy to automate it.

Could somebody tells me how do you
guys deal with these kind of problem?

Thanks  

-- 
Sent by  dbadba62 from hotmail  part from com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new