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

Report message to a moderator

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...

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 01:57:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.