Hi Athina, Open the properties dialog for your destination Oracle Feature Type. In this dialog click on the tab marked 'parameters'. There you'll find a number of options, one of which is 'Drop Existing Table'.
I'm not sure if that will keep the existing table structure or not. If this option doesn't work for you then check the navigation pane parameters for that writer. There is one called 'SQL Statement to Execute Before Translation' - I imagine you could put an SQL statement here to remove the table contents. Regards, Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- 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/
