Re: help: User defined datatype does not work across database link

u518615722_at_spawnkill.ip-mobilphone.net wrote:

> 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

Answer is standard: read documentation. Object stuff, including custom datatypes, doesn't work across database links. Received on Thu May 31 2001 - 22:43:37 CDT