An automatic job running via DBMS_JOB has failed. Knowing
only that "it's failed", how do you approach troubleshooting
this issue?
Answer Posted / braj123
>>First check the alert.log file for what reason the job
failed.
>>
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can you get actual data change values from previous transactions in oracle?
Why would you call update statistics? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What is dcl? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is a user-defined lock?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what functionality does oracle provide to secure sensitive information?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?