Category Archives: IMP Database Error Messages

IMP-00402: Invalid parameter “string” with data_only mode

oracle

IMP-00402: Invalid parameter “string” with data_only mode
Cause: Parameter provided along data_only is invalid.
Action: Remove the invalid parameter from command line.

Back to previous menu

IMP-00401: dump file “string” may be an Data Pump export dump file

oracle

IMP-00401: dump file “string” may be an Data Pump export dump file
Cause: A dump file was specified for an import operation which appears to have been created using the Data Pump export utility. These dump files cannot be processed by the original import utility.
Action: Try using the Data Pump import utility to process this dump file.

Back to previous menu

IMP-00400: Warning: Object type “string”.”string” already exists with a different typeid

oracle

IMP-00400: Warning: Object type “string”.”string” already exists with a different typeid
Cause: An object type could not be created because it already existed on the
* target system, but with a different typeid
Action: Drop the object type from the target system and retry the operation.

Back to previous menu

IMP-00099: Warning: The typeid in the dump file for object type “string”.”string” is invalid

oracle

IMP-00099: Warning: The typeid in the dump file for object type “string”.”string” is invalid
Cause: The character string representing the object type’s identifier
* could not be converted.
Action: Contact Oracle Worldwide Support.

Back to previous menu

IMP-00098: INTERNAL ERROR: string

oracle

IMP-00098: INTERNAL ERROR: string
Cause: An INTERNAL error occurred.
Action: Contact Oracle Worldwide Support.

Back to previous menu

IMP-00097: STREAMS_CONFIGURATION=Y ignored, only valid with FULL=Y

oracle

IMP-00097: STREAMS_CONFIGURATION=Y ignored, only valid with FULL=Y
Cause: STREAMS_CONFIGURATION=Y can only be used
* when FULL=Y is present on the command line
Action: Remove conflicting command arguments

Back to previous menu

IMP-00096: Warning: Skipping table “string”.”string” because type synonym “string”.”string” cannot be created

oracle

IMP-00096: Warning: Skipping table “string”.”string” because type synonym “string”.”string” cannot be created
Cause: An error occurred creating a synonym for a type that is used by the
* table.
Action: Examine the import log to determine why the type synonym could
* not be created. If the synonym already existed, but is not
* needed, then drop the synonym and retry the import. If the
* synonym is PUBLIC but the importer does not have the
* CREATE PUBLIC SYNONYM system privilege, then the import must
* be done by someone possessing that privilege, or the importer
* must be granted the privilege.
Action: Must specify RESUMABLE=Y to enable resumable session in order for the RESUMABLE_NAME and RESUMABLE_TIMEOUT parameters to take effect.

Back to previous menu

IMP-00095: Resumable parameters ignored — current session not resumable

oracle

IMP-00095: Resumable parameters ignored — current session not resumable
Cause: Current session is not resumable.
Action: Must specify RESUMABLE=Y to enable resumable session in order for the RESUMABLE_NAME and RESUMABLE_TIMEOUT parameters to take effect.

Back to previous menu

IMP-00094: Warning: The identifier on the dump file for object type “string”.”string” is invalid

oracle

IMP-00094: Warning: The identifier on the dump file for object type “string”.”string” is invalid
Cause: The character string representing the object type’s identifier
* could not be converted.
Action: Contact Oracle Worldwide Support.

Back to previous menu

IMP-00093: Inconsistency between dumpfile constraint definition for table string with columns (string)

oracle

IMP-00093: Inconsistency between dumpfile constraint definition for table string with columns (string)
Cause: Import failed to locate a base table for a constraint that was defined in the dump file and statistics were not imported.
Action: Check to see if the table and constraint exist. If the table and constraint exist, then report this to Oracle Support Services as an Import internal error.

Back to previous menu