Hi All, We also have same problem/issues in our project. I think, what athina wants is to remove old records ONLY. and insert new records. (am i right?)
so far, in FME parameters tab, it does not have options to truncate. (still not sure). we could use Begin_sql to remove/truncate the whole table. but this involves all records/features deleted and whole bunch of features are inserted again. if you want to remove only old records that are to be deleted. use changedetector and loop thru 'delete only' records to delete and insert only new records. regards, victor Dominic --- Mark Ireland <[EMAIL PROTECTED]> wrote: > > -----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 > > > [EMAIL PROTECTED] > > > > > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com 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/
