Oracle 10 to Oracle 11

Looking for some suggestions on a problem for a Database that was moved from Oracle 10g to Oracle 11.  We have a table that is written every 1/2 hour taking info from a User Table and updating to a Master table to be used at night for other systems.   The application works 100 % for everything else, but this process is not being executed.  We checked Triggers, Procedures and all else but cannot find anything in the original database  compared to the new database.  We are going to go back to the original server and try Oracle 10 again, but I cannot think of anything else.  Just looking for some suggestions.  Thanks
Startrac98Asked:
Who is Participating?
 
sdstuberCommented:
how is the writing scheduled?  something within Oracle?  dbms_job/dbms_scheduler   ?

Is job_queue_processes > 0
0
 
slightwv (䄆 Netminder) Commented:
'every 1/2 hour' implies a scheduled job of some type.

Check the database views in the original:
DBA_JOBS and DBA_SCHEDULER_JOBS.

Form the OS, check whatever job scheduler you have.  For example cron in Unix and Task Scheduler in Windows.
0
 
Startrac98Author Commented:
We isolated the pproblem to someone exec a Build on the Table from their PC.
0
 
sdstuberCommented:
I appreciate the points,  but how does http:#36561819 help?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.