hi Reshmi Jacob, maybe you can use this durty trick,

Oracle takes the date from SO, but you can also set a constant date temporality, and then set the S.O date again.

ALTER SYSTEM SET FIXED_DATE = '2007-01-01';

Done!!, you now have a constant sysdate, lol, but prolly you want to go back to the normal clock, couse this is constant and tomorroy will have the same date.

ALTER SYSTEM SET FIXED_DATE='non e';...