Database Administration (MOSC)

MOSC Banner

How to enable more information of what sqlplus was executing when ora-0942 occured.

edited Dec 29, 2009 12:40AM in Database Administration (MOSC) 6 commentsAnswered ✓
 I have the folowing errors in the laert log and will like to know how to enable in the database that when the error ora-942 occurs I can know what sqlplus or query was executing:
Sat Dec 19 21:22:20 2009
Errors in file /u01/apps/oracle/admin/flexpm/bdump/flexpm_smon_900.trc:
ORA-00942: table or view does not exist
Sat Dec 19 21:22:44 2009

flexpm_smon_900.trc

*** SESSION ID:(5.1) 2009-06-16 13:48:41.326
*** 2009-06-16 13:48:41.404
SMON: Parallel transaction recovery tried
*** 2009-06-23 10:24:09.020
SMON: following errors trapped and ignored:
ORA-00942: table or view does not exist
*** 2009-06-23 15:24:21.861
SMON: following errors trapped and ignored:
ORA-00942: table or view does not exist

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center