EXP-00053: unable to execute QUERY on table string because the table has inner nested tables

EXP-00053: unable to execute QUERY on table string because the table has inner nested tables

Cause: You specified the QUERY parameter on a table that has one or more inner nested tables. The QUERY parameter cannot be specified on tables that have inner nested tables.

Action: Export the entire table by omitting the QUERY parameter.

EXP-00052: error on row number of partition string

EXP-00052: error on row number of partition string

Cause: Export encountered the referenced Oracle error while fetching rows.

Action: Look up the Oracle message in the ORA message chapters of this manual and take appropriate action.

EXP-00051: string - given partition or subpartition name is not part of string table

EXP-00051: string - given partition or subpartition name is not part of string table

Cause: The specified partition or subpartition name is not in the specified table.

Action: Check if the correct table, partition or subpartition name was specified.

EXP-00050: Cannot perform Partition Export string on non-partitioned table string

EXP-00050: Cannot perform Partition Export string on non-partitioned table string

Cause: The table specified in this Partition Export is not a partitioned table.

Action: Use Table mode, or specify a non-partitioned table.

EXP-00049: %s option is not compatible with Point-in-time Recovery or Transportable Tablespace Export

EXP-00049: %s option is not compatible with Point-in-time Recovery or Transportable Tablespace Export

Cause: An option was specified incompatible with Point-in-time Recovery or Transportable Tablespace Export.

Action: Retry the Export without the displayed option.

EXP-00048: Cannot export SYSAUX Tablespace for Point-in-time Recovery or Transportable Tablespace

EXP-00048: Cannot export SYSAUX Tablespace for Point-in-time Recovery or Transportable Tablespace

Cause: SYSAUX tablespace cannot be part of recovery set or transportable tablespace set.

Action: Contact Oracle Wordwide Support.

EXP-00047: Missing tablespace name(s)

EXP-00047: Missing tablespace name(s)

Cause: Tablespace name(s) were not supplied

Action: Provide tablespace name(s)

EXP-00046: Tablespace named string does not exist

EXP-00046: Tablespace named string does not exist

Cause: The specified tablespace does not exist in dictionary.

Action: Contact Oracle Wordwide Support.

EXP-00045: Cannot export SYSTEM Tablespace for Point-in-time Recovery or Transportable Tablespace

EXP-00045: Cannot export SYSTEM Tablespace for Point-in-time Recovery or Transportable Tablespace

Cause: SYSTEM tablespace cannot be part of recovery set or transportable tablespace set.

Action: Contact Oracle Wordwide Support.

EXP-00044: must be connected AS SYSDBA to do Point-in-time Recovery or Transportable Tablespace import

EXP-00044: must be connected AS SYSDBA to do Point-in-time Recovery or Transportable Tablespace import

Cause: The user must log in as SYSDBA to perform transportable tablespace imports or Point-In-Time Recovery imports.

Action: Ask your database adminstrator to perform the Transportable Tablespace import or the Tablespace Point-in-time Recovery import.

EXP-00043: Invalid data dictionary information in the row where column string is string in table string

EXP-00043: Invalid data dictionary information in the row where column string is string in table string

Cause: The export utility retrieved invalid data from the data dictionary.

Action: Contact Oracle Worldwide Suport.

EXP-00042: Missing NLS_CHARACTERSET or NLS_NCHAR_CHARACTERSET in props$

EXP-00042: Missing NLS_CHARACTERSET or NLS_NCHAR_CHARACTERSET in props$

Cause: A value for NLS_CHARACTERSET or NLS_NCHAR_CHARACTERSET was not entered in the props$ table

Action: internal error.

EXP-00041: INCTYPE parameter is obsolete

EXP-00041: INCTYPE parameter is obsolete

Cause: Export encountered the INCTYPE parameter when parsing Export options. Incremental Exports are no longer supported.

Action: Consult the Oracle Backup and Recovery guide. Export will attempt to continue.

EXP-00040: Dump file and log file must be different

EXP-00040: Dump file and log file must be different

Cause: The dump file and log file cannot be the same file.

Action: Specify different file names for the dump file and the log file, then retry the operation.

EXP-00039: export file string must be on a disk

EXP-00039: export file string must be on a disk

Cause: On some platforms, export can read files from tape. This message is displayed if the first file in an export file set was on disk and you specified a tape device for a second or subsequent file.

Action: Verify that you have specified the correct file name for the export file. Remember that all export files can be either on disk or all files can be on tape, but not mixed both tape and disk.

EXP-00038: Bad Hash cluster id in clu$

EXP-00038: Bad Hash cluster id in clu$

Cause: The function id in clu$ is not a legal number. Clu$ has become corrupted.

Action: Contact Worldwide Support

EXP-00037: Export views not compatible with database version

EXP-00037: Export views not compatible with database version

Cause: The Export utility is at a higher version than the database version and is thereby incompatible.

Action: Use the same version of Export utility as the database.

EXP-00036: Object number non-existent in dictionary

EXP-00036: Object number non-existent in dictionary

Cause: The specified object could not be found in the dictionary. The object might have been dropped during the export

Action: The object no longer exists; no action is needed.

EXP-00035: QUERY parameter valid only for table mode exports

EXP-00035: QUERY parameter valid only for table mode exports

Cause: You specified the QUERY parameter in an export command, but you are not performing a table mode export. The QUERY parameter cannot be used for a user mode export, a full export, nor a point in time recovery export.

Action: If you want to select a subset of rows for a table, you must export the table independently with a table mode export. Issue a table mode export command that specifies the table name and the query you want to execute during export.

EXP-00034: error on rowid: file# number block# number slot# number

EXP-00034: error on rowid: file# number block# number slot# number

Cause: Identifies the rowid on which an error occurred.

Action: This is an information message. No action is required.

EXP-00033: Could not find environment character set

EXP-00033: Could not find environment character set

Cause: The environment character set is missing or incorrectly specified.

Action: Ensure that the environment character set is correctly specified and is present.

EXP-00032: Non-DBAs may not export other users

EXP-00032: Non-DBAs may not export other users

Cause: Only database administrators can export to other users. A non- database administrator attempted to specify owner=user where exporter is not the user.

Action: Request that this operation be performed by the database administrator.

EXP-00031: Arraysize not in valid range. Using arraysize=number

EXP-00031: Arraysize not in valid range. Using arraysize=number

Cause: The arraysize value specified is not in the valid range.

Action: None

EXP-00030: Unexpected End-Of-File encountered while reading input

EXP-00030: Unexpected End-Of-File encountered while reading input

Cause: Encountered an End-Of-File while reading the user input.

Action: If input to export is being redirected, check the file for errors.

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

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.

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

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.

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

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.

IMP-00021: INCTYPE parameter is obsolete

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.

IMP-00020: long column too large for column buffer size (number)

IMP-00020: long column too large for column buffer size (number)

Cause: The column buffer is too small. This usually occurs when importing LONG data.

Action: Increase the insert buffer size 10,000 bytes at a time (for example). Use this

IMP-00019: row rejected due to ORACLE error number

IMP-00019: row rejected due to ORACLE error number

Cause: Import encountered the referenced Oracle error while trying to import a row.

Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.

IMP-00018: partial import of previous table completed: number rows imported

IMP-00018: partial import of previous table completed: number rows imported

Cause: A table was only partially imported because of an Oracle error.

Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.

IMP-00017: following statement failed with ORACLE error number:

IMP-00017: following statement failed with ORACLE error number:

Cause: Import failed to execute the statement from the export file because of an Oracle error.

Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.

IMP-00016: required character set conversion (type number to number) not supported

IMP-00016: required character set conversion (type number to number) not supported

Cause: Import could not convert the character format of the export file into the native character format.

Action: Change the user character set by setting the NLS_LANG environment variable to match the character set of the export file.

IMP-00015: following statement failed because the object already exists:

IMP-00015: following statement failed because the object already exists:

Cause: Import failed to create an object because it already exists.

Action: Specify IGNORE=Y to ignore such errors and import rows even when tables are not created because they already exist.

IMP-00014: option string is needed, but not present in database

IMP-00014: option string is needed, but not present in database

Cause: The command entered requires the specified option. Either that option is not installed, or the row describing the option is missing from table V$OPTION

Action: Reinstall Oracle with the option specified by the message.

IMP-00013: only a DBA can import a file exported by another DBA

IMP-00013: only a DBA can import a file exported by another DBA

Cause: The privileges needed to Import an export file generated by a database administrator do not exist. Only a database administrator can import such files.

Action: Ask the database administrator to do the import.

IMP-00012: invalid export mode (character) in header

IMP-00012: invalid export mode (character) in header

Cause: The Export mode specified in the export file header is invalid.

Action: Check the export file to see if it was corrupted. If it was not, report this as an Import bug and submit the export file to customer support.

IMP-00011: formatted table data not currently supported

IMP-00011: formatted table data not currently supported

Cause: You tried to import an export file that contains formatted table data. Import only supports export files containing binary table data. wher

Action: Retry using an export file that contains only binary table data.

IMP-00010: not a valid export file, header failed verification

IMP-00010: not a valid export file, header failed verification

Cause: Either the file was not generated by Export or it was corrupted.

Action: If the file was indeed generated by Export, report this an Import bug and submit the export file to customer support.

IMP-00009: abnormal end of export file

IMP-00009: abnormal end of export file

Cause: The export file is probably from an aborted Export session.

Action: If so, retry the export and import. Otherwise, report this as an Import bug and submit the export file that caused this error to customer support.

IMP-00008: unrecognized statement in the export file: string

IMP-00008: unrecognized statement in the export file: string

Cause: Import did not recognize a statement in the export file. Either the export file was corrupted, or an Import internal error has occurred.

Action: If the export file was corrupted, retry with a new export file. Otherwise, report this as an Import internal error and submit the export file to customer support.

IMP-00007: must be a DBA to import objects to another user s account

IMP-00007: must be a DBA to import objects to another user s account

Cause: The privileges needed to import into another user s account do not exist. Only a database administrator can import into another user s account.

Action: Ask the database administrator to do the import.

IMP-00006: failed to allocate memory of size number

IMP-00006: failed to allocate memory of size number

Cause: Import failed to allocate the necessary memory.

Action: Decrease the import buffer size so that less memory is required, or increase the runtime memory size for Import.

IMP-00005: all allowable logon attempts failed

IMP-00005: all allowable logon attempts failed

Cause: An attempt was repeatedly made to log on with an invalid username or password.

Action: Retry with valid username and password.

IMP-00004: invalid username or password

IMP-00004: invalid username or password

Cause: An invalid username or password was specified.

Action: Retry with a valid username and password.

IMP-00003: ORACLE error number encountered

IMP-00003: ORACLE error number encountered

Cause: Import encountered the referenced Oracle error.

Action: Look up the Oracle message in the ORA message chapters of this manual, and take appropriate action.

IMP-00002: failed to open string for read

IMP-00002: failed to open string for read

Cause: Import failed to open the export file for reading. This message is usually followed by a device message from the operating system.

Action: Take appropriate action to restore the device.

IMP-00001: respond with either string, string, RETURN or . to quit

IMP-00001: respond with either string, string, RETURN or . to quit

Cause: An invalid response was entered.

Action: Enter any of the responses shown in the message.

IMP-00000: Import terminated unsuccessfully

IMP-00000: Import terminated unsuccessfully

Cause: Import encountered an Oracle error.

Action: Look up the accompanying Oracle message in the ORA message chapters of this manual, and take appropriate action.

EXP-00107: Feature (string) of column string in table string.string is not supported. The table will not be exported.

EXP-00107: Feature (string) of column string in table string.string is not supported. The table will not be exported.

Cause: Export does not contain the required support for this feature. The table will not be exported.

Action: Use the Data Pump version of Export to export this table.

EXP-00106: Invalid Database Link Passwords

EXP-00106: Invalid Database Link Passwords

Cause: Invalid Encoded Password for Database Link

Action: Please drop the Database Link and recreate it after import.

EXP-00105: parameter string is not supported for this user

EXP-00105: parameter string is not supported for this user

Cause: The user attempted to specify either CONSISTENT or OBJECT_ CONSISTENT when connected as sysdba.

Action: If a consistent export is needed, then connect as another user.

EXP-00104: datatype (string) of column string in table string.string is not supported, table will not be exported

EXP-00104: datatype (string) of column string in table string.string is not supported, table will not be exported

Cause: The column is of a datatype which does not contain the required support. The table will not be exported.

Action: Use the Data Pump version of Export to export this table.

EXP-00103: The FLASHBACK_TIME parameter was invalid

EXP-00103: The FLASHBACK_TIME parameter was invalid

Cause: FLASHBACK_TIME did not contain a valid timestamp or an expression that yields a valid timestamp.

Action: Specify a timestamp value in the format of YYYY-MM-DD HH24:MI:SS or an expression that evaluates to a valid timestamp.

EXP-00102: Resumable parameters ignored -- current session not resumable

EXP-00102: 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.

EXP-00101: Version 1 extensible index string . string can not be included in Transportable Tablespace Export

EXP-00101: Version 1 extensible index string . string can not be included in Transportable Tablespace Export

Cause: Transporable Tablespace extensible indexes must be at least version 2.

Action: Upgrade extensibile index implementation to version 2 specifications.

EXP-00100: error converting an object type s hashcode to characters

EXP-00100: error converting an object type s hashcode to characters

Cause: An invalid length of an object type identifier prevented its conversion.

Action: Contact Oracle Worldwide Support

EXP-00099: Table string . string is not in a valid state, table will not be exported

EXP-00099: Table string . string is not in a valid state, table will not be exported

Cause: A table or one of its dependant types has modified without cascading the change. This left the table in an INVALID state.

Action: The table must be updated using ALTER TABLE UPDATE.

EXP-00098: Data in table has not been upgraded, table will not be exported

EXP-00098: Data in table has not been upgraded, table will not be exported

Cause: Export is attempting to process a table containing references to a type which has evolved. In order for Export to process the table successfully, all data within each table must be upgraded to the latest revision of each referenced type.

Action: The table must be updated using ALTER TABLE UPGRADE DATA.

EXP-00097: Object type string . string is not in a valid state, type will not be exported

EXP-00097: Object type string . string is not in a valid state, type will not be exported

Cause: The object type s status is invalid which may be caused by a dependant type s modification (or removal) without cascading the change.

Action: The type must be recompiled using ALTER TYPE COMPILE.