-----Original Message----- From: chrigl [mailto:[EMAIL PROTECTED] Sent: Tuesday, 29 November 2005 11:37 PM To: [EMAIL PROTECTED] Subject: Re: Updating Spatial Data In Oracle
Hi Athina You have at least two alternatives to realize that with sql-orders. 1. 'truncate' the table, before you update (keeps the structure of the table) 2. 'drop table' and 'create table' (you have to create the structure) I'll propose you the first possibility. In DetaiL: 1. create a *.sql-file (e.g. truncate.sql) with a text-editor - add the connection-string to your database in this file (e.g. connect %USER%/[EMAIL PROTECTED]; ) - add the truncate-statement (e.g. truncate table areas;) - add the truncate-statement (e.g. truncate table lines;) ... - add the commit-statement: commit; - add the exit clause: exit 2. create a '*.bat' - File. - In this Batch-File you call the sql-file like this: sqlplus /nolog @truncate.sql 3. schedule the Batch-File before you run the fme-script hope. this helps Gruss Christoph --- In [email protected], "Athina" <[EMAIL PROTECTED]> wrote: > > Hi, > > I am using Oracle 10g and have some existing spatial tables, which I > want to update on a regular basic using FME. I have been running a > scheduled task for a few weeks now, and have just realised that the > data is appending to the exisiting tables in oracle but I would prefer > to overwrite all the records but keep the exisitng table structure. > > Does anyone know of a way within FME to force it to overwrite or > delete exisiting records before adding then new records? > > Thanks! > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
