Database Administration (MOSC)

MOSC Banner

IDX_RB$J_27691_ JOB

edited Oct 28, 2009 9:35AM in Database Administration (MOSC) 3 commentsAnswered
In the traces I found the wrong command:
   ALTER SESSION SET "db_file_name_convert" = /data/FTC, /data/FTC
which will be executed by user SYS during a database job by the DBMS_SCHEDULER

We have a job that is executing the wrong alter is IDX_RB$J_27691_ , I found alot of IDX jobs, can we safely drop this to avoid the error that we are encountering of performing the wrong alter.

If I can drop this, How can we do so?

Appreciate your quick help,

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center