Category Archives: IMP Database Error Messages

IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments

oracle

IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
Cause: The database administrator did not specify full or partial import.
Action: The database administrator must specify FROMUSER/TOUSER or table arguments if not a full import.

Back to previous menu

IMP-00030: failed to create file string for write

oracle

IMP-00030: failed to create file string for write
Cause: Import was unable to create the specified file with write enabled.
Action: Check the file name and file system for the source of the error.

Back to previous menu

IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter

oracle

IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter
Cause: A table name was qualified with the name of its owner, as shown in the following example. This is not allowed. IMP SYSTEM/MANAGER TABLES=(SCOTT.EMP)
Action: Use the FROMUSER parameter to specify the table’s owner, as shown in the following example: IMP SYSTEM/MANAGER FROMUSER=SCOTT TABLES=(EMP, DEPT)

Back to previous menu

IMP-00028: partial import of previous table rolled back: number rows rolled back

oracle

IMP-00028: partial import of previous table rolled back: number rows rolled back
Cause: Import encountered an Oracle error while trying to import a table.
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action. Then, if necessary, re-import the table.

Back to previous menu

IMP-00027: failed to rollback partial import of previous table

oracle

IMP-00027: failed to rollback partial import of previous table
Cause: Import encountered an Oracle error while trying to roll back a partial import.
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action. Then, log on to Oracle and check that the partial import was not committed.

Back to previous menu

IMP-00025: for DBA export files, FROMUSER must be specified with TOUSER option

oracle

IMP-00025: for DBA export files, FROMUSER must be specified with TOUSER option
Cause: When importing a database administrator export file, you specified the TOUSER parameter but not the FROMUSER parameter.
Action: Specify the FROMUSER parameter so that Import knows which user’s objects to import.

Back to previous menu

IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified

oracle

IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified
Cause: Parameters were specified that conflict with the import specification FULL=Y
Action: Retry, making sure not to specify FULL=Y.

Back to previous menu

IMP-00023: Import views not installed, please notify your DBA

oracle

IMP-00023: Import views not installed, please notify your DBA
Cause: The necessary Import views were not installed.
Action: Ask your database administrator to install the required Import views.

Back to previous menu

IMP-00022: failed to process parameters, type ‘IMP HELP=Y’ for help

oracle

IMP-00022: failed to process parameters, type ‘IMP HELP=Y’ for help
Cause: Invalid command-line parameters were specified.
Action: Check the online help screen for the set of valid parameters, then retry.

Back to previous menu

IMP-00021: INCTYPE parameter is obsolete

oracle

IMP-00021: INCTYPE parameter is obsolete
Cause: Import encountered the INCTYPE parameter when parsing Import options. Incremental Imports are no longer supported.
Action: Consult the Oracle Backup and Recovery guide. Import will attempt to continue.

Back to previous menu