As far as i think you must make a script which should run thru crontab at specific time. You can use the SU command to substitute to root and run the script under his privileges and then again come back to Oracle user.