Tuesday, 19 June 2012

ORA-39028: cannot restart job from string state

ORA-39028: cannot restart job from string state

Cause: The job was not in a suitable state for restart. Jobs must begin executing before they can be restarted.

Action: Recreate the job.

ORA-39027: wrong version of master table

ORA-39027: wrong version of master table

Cause: Job cannot be restarted because the version of the database upon which the job started is different than the current version of the database and the format of the master table has changed between the versions.

Action: Recreate the job.

ORA-39026: master table is inconsistent on validation string

ORA-39026: master table is inconsistent on validation string

Cause: Job cannot be restarted because it failed a validation check. Validation checks are of the form -xx.y where -xx is the value of the PROCESS_ORDER column in the master table where the error was detected and y is the actual validity check for the row.

Action: Recreate the job. If master table has not been modified, but problem persists, contact Oracle Customer Support.

ORA-39025: jobs of type string are not restartable

ORA-39025: jobs of type string are not restartable

Cause: Attempt to restart a job which was not restartable.

Action: Recreate the job via the open API.

ORA-39024: wrong schema specified for job

ORA-39024: wrong schema specified for job

Cause: Internal error caused by the master process finding inconsistencies between the schemas specified for the job.

Action: Contact Oracle Customer Support.

ORA-39023: Version string is not supported.

ORA-39023: Version string is not supported.

Cause: User specified an explicit version on an DBMS_DATAPUMP.OPEN API, but the current database version is not supported by the Data Pump API. Database versions before 9.2 are not supported by the Data Pump.

Action: Specify a supported version and recreate the job.

ORA-39022: Database version string is not supported.

ORA-39022: Database version string is not supported.

Cause: User selected LATEST as the version on an DBMS_DATAPUMP.OPEN API, but the current database version is not supported by the Data Pump API. Database versions before 9.2 are not supported by the Data Pump.

Action: Specify a supported version and recreate the job.