Unanswered: Automatically coalesce tablespaces problem
I created a procedure and run it as a job. This job wouldl run every 3 hours to find all tablespaces that have "%extents coalesced" less than 100 and would coalesce them.
The job runs (as ORACLE - has DBA privileges and owns the procedure) find with most of tablespaces except for 2 tablespaces (RBS, and USER_TMP). When the job tries to coalesce these 2 tablespaces, I got this error: "insufficient privileges". However, I can manually coalesce these 2 tablespaces (as ORACLE)
Why can ORACLE account cannot have privileges to run this job ?