19.10
Have a new job coming in that will use very large amount of temp so want to allocate a temp tablespace to the job for its duration. Historically we would do something like (code taken from elsewhere back from oracle 10, I cant find if an “alter session set temp space” has become a feature since.)
Create dedicated NEW_TEMP tablespace on additional storage
b. ALTER USER username TEMPORARY TABLESPACE NEW_TEMP
c. Run the batch
d. ALTER USER username TEMPORARY TABLESPACE NORMAL_TEMP
e. DROP TABLESPACE NEW_TEMP
This works.
The job comes in as a scheduler job submit and calls a scheduler job which calls a proc which runs a pretty resource intensive job, we need to do it this way to force the use of a particular instance which we can do by setting an attribute. If we allocate the temp space above which user do we change.
The user that submitted the job?
The owner of the procedure?
The owner of the job?