Database Administration (MOSC)

MOSC Banner

11.1.0.7 Database -full import shows the following failed sql

edited Nov 16, 2010 5:06PM in Database Administration (MOSC) 3 commentsAnswered ✓
The following sql is shown on the full import log and when I try to run it in sqlplus as sys it gave me the following error: Any help will be appreciated:

SQL>  BEGIN SYS.DBMS_IJOB.SUBMIT( JOB=> 1, LUSER=> 'SYS', PUSER=> 'ADMUSER', CUS
ER=>'ADMUSER', NEXT_DATE=> TO_DATE('2010-11-07 21:16:00', 'YYYY-MM-DD:HH24:MI:SS
'),
  2  INTERVAL=> 'TRUNC(SYSDATE+(1/1400),''MI'')', BROKEN=>  FALSE, WHAT=> 'syste
m_monitor;', NLSENV=> 'NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_C
URRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA'' NLS_NUMERIC_CHARACTERS=''.,'' NL
  3  /
ERROR:
ORA-01756: quoted string not properly
terminated




 ORA-39083: Object type JOB failed to create with error:

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