I need to make some changes to a few views periodically and need to have the statements run after hours. I have read other posts trying to figure out the best way as the solutions don’t quite fit my needs, or I am not understanding. Please help me understand the proper tool for the job.
I have two or three CREATE OR REPLACE VIEW statements and occasionally a stored procedure or package to update on our production server from a test server. I can create the statements and run them in the editor as a script, but I need schedule them to run after business hours. What is the best method to schedule these types of object updates to run in the evening?
I am relatively current with TOAD for Oracle 188.8.131.52
Thank you for your help.