This content has been marked as final. Show 2 replies
There are at least two ways haw to do it.
1/ run your sql script using SQL*Plus from command line. Use cron on Unix/Linux or Task schedule(at) on Windows to schedulre when to run.
-- connct to instance
-- do you work
select * from v$instance;
-- exit script
sqlplus /nolog @a.sql
2/ create a job directly in DB. When you use ORACLE Scheduler you can create job of type executable.This type of job is able to run any shell script so you can user sql script from example 1/.
Or create stored procedure that do same as sql script and run this procedure in job.
Great, thanks... I asked the Admin to grant me permission to create a table at the user level and not at the Role level.
I did a simple test using a stores pl/sql proc and I was able to create a table and then drop it.
So now I will write my PL/SQL and test it manually and then off to learn the Scheduler, so cool!
thanks for the tips!