I want to import data into an Oracle table from SQL Server. I need to do this once a week for a certain table. I need the Oracle table to be truncated before the new data from the new week is inserted. I already have a trigger on the Oracle table to not let nulls in from a certain field. Can I make another trigger that will truncate the table? And how can I be sure that the truncate trigger will fire before the delete_nulls trigger?
I have a table in SQL Server. I want to transfer this table to Oracle. In my SQL Server table there are values with null that I don't want in the Oracle table. The problem is, that when I transfer the table to Oracle, the data thats in the Oracle table from another data transfer is still there. I want to truncate the Oracle table and then transfer the data from SQL Server to the empty Oracle table, but without the lines with the null values. Is this a better explanation?
Since you are using a DTS package, why not use SQL to select only the rows from the SQL Server you want to insert? You could also use a Truncate or Delete task first and forget about the Oracle triggers.