Oracle Solution for Error ora-39178
ORA-39178: cannot perform estimate on metadata only jobs
What triggered the Error:
An estimate was requested for a job by specifying the ESTIMATE or ESTIMATE_ONLY parameter. However, the job was also defined to have no data. These specifications conflict with each other.
What should we do to fix it:
Remove one of the conflicting specifications for the job.