Home » Server Options » Spatial » copying geom data from one table to another
copying geom data from one table to another [message #75819] Mon, 12 January 2004 11:21 Go to next message
David Darlington
Messages: 2
Registered: January 2004
Junior Member
I have a database table which contains a number of columns including a geom column.  I need to copy some of the columns from this table, including the geom column, into a new database table.

Is there any easy way of doing this in Oracle?

Cheers,

David
Re: copying geom data from one table to another [message #75833 is a reply to message #75819] Tue, 06 July 2004 18:57 Go to previous message
Prasanna Banna
Messages: 1
Registered: July 2004
Junior Member
Hey David,
You could use a DB link.

Steps -

Create a DB Link from DB1(Database into which records are to be inserted) to DB2
Use a Query to
Insert into DB1.Table(A,B,C) values(select A,B,C from DB2.Table)

Hope this helps...
Previous Topic: loading a raster in Oracle 9i
Next Topic: something is wrong when i use "sdo_geor.subset"
Goto Forum:
  


Current Time: Mon May 17 12:29:55 CDT 2021