Solved

Oracle 10 to Oracle 11

Posted on 2011-09-19
4
299 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:Startrac98
  • 2
4 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36561814
'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
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 36561819
how is the writing scheduled?  something within Oracle?  dbms_job/dbms_scheduler   ?

Is job_queue_processes > 0
0
 

Author Closing Comment

by:Startrac98
ID: 36563107
We isolated the pproblem to someone exec a Build on the Table from their PC.
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 36563116
I appreciate the points,  but how does http:#36561819 help?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now