Discarding Seed Data Modifications
Use the following procedure to discard seed data modifications.
To discard seed data modifications
In Siebel Tools, select the Table object.
In the list applet, query for
“*in the Seed Filter column.The query returns a list of tables containing seed data.
Use one of the following scripts to set LAST_UPD to 1980-01-01 for customized seed data records in these tables. In the scripts, tablename is the name of table containing seed data.
Database Script Oracle Database
UPDATE tablename SET LAST_UPD = TO_DATE('1980-01-01', 'YYYY-MM-DD') WHERE ROW_ID LIKE '0%' AND LAST_UPD > TO_DATE('1980-01-01', 'YYYY-MM-DD')IBM DB2 and IBM DB2 for z/OS
UPDATE tablename SET LAST_UPD = TIMESTAMP('1980-01-01-00.00.00') WHERE ROW_ID LIKE '0%' AND LAST_UPD > TIMESTAMP('1980-01-01-00.00.00')Microsoft SQL Server
UPDATE tablename SET LAST_UPD = CONVERT(DATETIME,'1980-01-01') WHERE ROW_ID LIKE '0%' AND LAST_UPD > CONVERT(DATETIME,'1980-01-01')
Related Topics
About the Siebel Database Upgrade Log Files