Re: Help me!!!

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 16 Feb 2012 13:06:27 +0000 (UTC)
Message-ID: <pan.2012.02.16.13.06.27_at_gmail.com>

On Wed, 15 Feb 2012 17:29:48 -0800, onedbguru wrote:

> The error message is self-explanatory! ORA-00942: table or view does
> not exist. Look at the job. Look at ORA-06550: line 2, column 3: What
> does it do? What tables does it touch? Did someone change the
> permissions/accessibility of that table? Do you have {EXP/IMP}
> _FULL_DATABASE role?

He could also do something like this:

"ALTER SYSTEM SET EVENTS='942 TRACE NAME ERRORSTACK FOREVER, LEVEL 12'" That would produce the exact SQL in $ORACLE_BASE/diag/rdbms/$SERVICE_NAME/ $ORACLE_SID/trace, which is the location formerly known as "USER_DUMP_DEST". Good thing that Oracle has simplified looking for traces.

Depending on the nature of the missing table, he can continue his investigation.

-- 
http://mgogala.byethost5.com

Received on Thu Feb 16 2012 - 07:06:27 CST