When I create a job scheduler to perform a maintenance task gives me the following error.
ERROR at line 1:
ORA-27452: JOB _ / \ / \ / _ 10 is an invalid name for a database object.
ORA-06512: at “SYS.DBMS_ISCHED”, line 124
ORA-06512: at “SYS.DBMS_SCHEDULER”, line 271
ORA-06512: at line 2
In this case, the problem is in the string / \ / \ / (AN, my initials), have a habit of putting it to identify my things. Removing the “ANR” works. Another option is to use double quote in the definition of the job, as in the following example;
BEGIN DBMS_SCHEDULER.create_job ( job_name => '"JOB_/\/\_15"', job_type => 'PLSQL_BLOCK', job_action => 'BEGIN NULL; END;', start_date => SYSTIMESTAMP, repeat_interval => 'freq=hourly; byminute=0; bysecond=0;', end_date => NULL, enabled => TRUE, comments => 'Job de prueba /\/\/.'); END; /
HTH – Antonio NAVARRO