Oracle8i Error Messages Release 2 (8.1.6) A76999-01 |
|
This chapter lists messages generated by the Export utility. For more information about this utility, refer to Oracle8i Utilities.
EXP-00000 Export terminated unsuccessfully
Cause: Export encountered an Oracle error.
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual, and take appropriate action.
EXP-00001 data field truncation - column length=number, buffer size=number actual size=number
Cause: Export could not fit a column in the data buffer.
Action: Record the given size parameters and the accompanying messages and report this as an Export internal error to Oracle Customer Support. (Part of the table has been exported. Export will continue with the next table.)
EXP-00002 error in writing to export file
Cause: Export could not write to the export file, probably because of a device error. This message is usually followed by a device message from the operating system.
Action: Take appropriate action to restore the device.
EXP-00003 no storage definition found for segment(number, number)
Cause: Export could not find the storage definitions for a cluster, index, or table.
Action: Record the accompanying messages and report this as an Export internal error to Oracle Customer Support.
EXP-00004 invalid username or password
Cause: An invalid username or password was specified.
Action: Retry with a valid username and password.
EXP-00005 all allowable logon attempts failed
Cause: Attempts were repeatedly made to log on with an invalid username or password.
Action: Shut down the utility, then restart and retry with a valid username and password.
EXP-00006 internal inconsistency error
Cause: Export's data structure was corrupted.
Action: Record the accompanying messages and report this as an Export internal error to Oracle Customer Support.
EXP-00007 dictionary shows no columns for string.string
Cause: Export failed to gather column information from the data dictionary. The table may have been dropped.
Action: Retry the export and, if this error recurs, report it as an Export internal error to Oracle Customer Support.
EXP-00008 ORACLE error number encountered
Cause: Export encountered the referenced Oracle error.
Action: Look up the Oracle message in the ORA message chapters of this manual and take appropriate action.
EXP-00009 no privilege to export string's table string
Cause: An attempt was made to export another user's table. Only a database administrator can export another user's tables.
Action: Ask your database administrator to do the export.
EXP-00010 string is not a valid username
Cause: An invalid username was specified.
Action: Shut down the utility, then restart and retry with a valid username.
EXP-00011 string.string does not exist
Cause: Export could not find the specified table.
Action: Retry with the correct table name.
EXP-00012 string is not a valid export mode
Cause: An invalid export mode was specified.
Action: Retry with a valid export mode.
EXP-00013 respond with either 'Y', 'N', RETURN or '.' to quit
Cause: An invalid response was entered.
Action: Enter any of the responses shown in the message.
EXP-00014 error on row number of table string
Cause: Export encountered an Oracle error while fetching rows.
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.
EXP-00015 error on row number of table string, column string, datatype number
Cause: Export encountered an error while fetching or writing the column. An accompanying message gives more information.
Action: Correct the error and try again.
EXP-00016 ORACLE error encountered while reading default auditing options
Cause: Export encountered an Oracle error while reading the default auditing options (those for updates, deletes, and so on).
Action: Look up the accompanying Oracle message in the ORA message chapters of this manual and take appropriate action.
EXP-00017 feature 'string' is needed, but not present in database"
Cause: The command entered requires the specified feature. Either that feature is not installed, or the row describing the feature is missing from table V$OPTION.
Action: Re-install Oracle with the feature specified in the message.
EXP-00018 datatype (number) for column string, table string.string is not supported
Cause: Export does not support the referenced datatype.
Action: Retry with an acceptable datatype (CHAR, NUMBER, DATE, LONG, or RAW).
EXP-00019 failed to process parameters, type 'EXP 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.
EXP-00020 failed to allocate memory of size number
Cause: Export failed to allocate the necessary memory.
Action: Decrease the export buffer size so that less memory is required, or increase the runtime memory size for Export.
EXP-00021 can only perform incremental export in Full Database mode
Cause: USER or TABLE mode was specified when doing an incremental export.
Action: Specify FULL database mode (FULL=Y) and retry.
EXP-00022 must be SYS or SYSTEM to do incremental export
Cause: The privileges needed to do an incremental export do not exist. Only a data base administrator can do incremental exports.
Action: Ask the database administrator to do the incremental export.
EXP-00023 must be a DBA to do Full Database export
Cause: The privileges needed to do a FULL database export do not exist. Only a database administrator can do a FULL database export.
Action: Ask the database administrator to do the FULL database export.
EXP-00024 Export views not installed, please notify your DBA
Cause: The necessary Export views were not installed.
Action: Ask the database administrator to install the required Export views.
EXP-00025 dictionary shows no column for constraint string.number
Cause: Export failed to gather column information about the referenced constraint from the data dictionary. The constraint may have been altered.
Action: Retry the export and, if this error recurs, report it as an Export internal error to Oracle Customer Support.
EXP-00026 conflicting modes specified
Cause: Conflicting export modes were specified.
Action: Specify only one parameter and retry.
EXP-00027 failed to calculate ORACLE block size
Cause: Export failed to calculate the Oracle block size.
Action: Report this as an Export internal error to Oracle Customer Support.
EXP-00028 failed to open string for write
Cause: Export failed to open the export file for writing. This message is usually followed by device messages from the operating system.
Action: Take appropriate action to restore the device.
EXP-00029 Incremental export mode and consistent mode are not compatible
Cause: Both consistent and incremental exports were specified.
Action: No action is required. Consistent mode is turned off.
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.
EXP-00031 Arraysize not in valid range. Using arraysize=number
Cause: The array size value specified is not in the valid range.
Action: No action required.
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-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-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-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-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-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-00038 Bad Hash cluster id in clu$
Cause: The function ID in CLU$ is not a legal number. CLU$ has become corrupted.
Action: Contact Oracle Customer Support.
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-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-00041 Export done in server's string, different from user's character set string
Cause: The specified NLS_LANG/NLS_NCHAR parameter is incompatible with the value specified for the server in props$.
Action: Change the client's value for NLS_LANG/NLS_NCHAR to server's value and retry the operation.
EXP-00042 Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$
Cause: A value for NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET was not entered in the props$ table. This is an internal error.
Action: Contact Oracle Customer Support.
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 Customer Support.
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-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 Customer Support.
EXP-00046 Tablespace named string does not exist
Cause: The specified tablespace does not exist in dictionary.
Action: Contact Oracle Customer Support.
EXP-00047 Missing tablespace name(s)
Cause: Tablespace name(s) were not supplied.
Action: Provide tablespace name(s).
EXP-00048 Tablespace mode not supported for normal export
Cause: The tablespace option cannot be specified for this export mode.
Action: Use the tablespace option only with the Point-in-time Recovery or Transportable Tablespace options set.
EXP-00049 string option is not compatible with Point-in-time Recovery or Transportable Tablespace export
Cause: An option was specified that is incompatible with Point-in-time Recovery or Transportable Tablespace Export.
Action: Retry the export without the displayed option.
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-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-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-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-00054 error on row number of subpartition 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-00055 string.string is marked not exportable
Cause: An object was marked as non-exportable in the NOEXP$ table.
Action: Consult your database administrator.
EXP-00057 Failure to initialize parameter manager
Cause: The parameter manager failed in intialization.
Action: Record the messages that follow and report this to Oracle Customer Support as an Export internal bug.
EXP-00058 Password Verify Function for string profile does not exist
Cause: Cannot find the function for the profile.
Action: Check if the profile was created properly.
EXP-00059 error converting an object type's identifier to characters
Cause: An invalid length of an object type identifier prevented its conversion.
Action: Contact Oracle Customer Support.
EXP-00060 an object type had multiple TYPE BODYs
Cause: More than one TYPE BODY was found for an object type.
Action: Try dropping the TYPE BODY, if that is not successful, contact Oracle Customer Support.
EXP-00061 unable to find the outer table name of a nested table
Cause: While exporting a bitmap index or postable action on an inner nested table, the name of the outer table could not be located, using the NTAB$ table.
Action: Verify the table is properly defined.
EXP-00062 invalid source statements for an object type
Cause: TYPE was not found in the statements in SOURCE$ for an Object Type.
Action: Contact Oracle Customer Support.
EXP-00063 error in changing language handle
Cause: Unable to change language handle.
Action: Contact Oracle Customer Support.
EXP-00064 string is an inner nested table and connot be exported.
Cause: An attempt was made to export an inner nested table without its parent table.
Action: Export the parent of the inner nested table.
EXP-00065 Error writing lob to the dump file.
Cause: The current LOB could not be written to the dump file.
Action: Identify the cause of the write failure and fix it.
EXP-00066 Object table string is missing its object identifier index
Cause: All object tables must have an object identifier index, but the specified table was missing an index on its object identifier column.
Action: Re-create the type table and retry the operation.
EXP-00067 Table string will be exported in conventional path.
Cause: Direct path export cannot export tables that contain LOBs, files, or object datatypes. Instead, conventional path will be used to export the data in the specified table.
Action: No action required. This is an informational message only.
EXP-00068 tablespace string is offline
Cause: Export failed to export tablespace (tablespace being offline).
Action: Make tablespace online and re-export.
EXP-00070 attempt to free unallocated memory
Cause: An attempt was made to free memory that was not allocated.
Action: Contact Oracle Customer Support.
EXP-00071 QUERY parameter not compatible with Direct Path export
Cause: You specified a value for the QUERY parameter for a direct path export. The QUERY parameter cannot be used with a direct path export.
Action: Re-issue the export command with DIRECT=N or omit the DIRECT parameter from the command line.
EXP-00072 error closing export file string
Cause: An error occurred while trying to close the export file.
Action: Contact Oracle Customer Support.
EXP-00073 dump file size too small
Cause: You specified either the FILESIZE parameter or the VOLSIZE parameter (if your platform supports it), and the value of the parameter is too small to hold the header information for the export file, plus any data.
Action: Increase the value of the FILESIZE or VOLSIZE parameter.
EXP-00074 rounding VOLSIZE down, new value is string
Cause: The VOLSIZE parameter must be a multiple of the RECORDLENGTH, but the value you specified for VOLSIZE does not meet this requirement. The value of VOLSIZE has been rounded down to be a multiple of the RECORDLENGTH used for the dump file.
Action: No action is required. You can adjust the VOLSIZE or RECORDLENGTH parameter to avoid this message. When importing this file, you must specify the VOLSIZE value reported by this message.
EXP-00075 rounding FILESIZE down, new value is string
Cause: The FILESIZE parameter must be a multiple of the RECORDLENGTH, but the value you specified for FILESIZE does not meet this requirement. The value of FILESIZE has been rounded down to be a multiple of the RECORDLENGTH used for the dump file.
Action: No action is required. You can adjust the FILESIZE or RECORDLENGTH parameter to avoid this message. When importing this file, you must specify the FILESIZE value reported by this message.
EXP-00076 multiple devices specified for tape output
Cause: You specified multiple file names when doing an export to a tape device. EXPORT uses the same device for writing all files, of the number of tape volumes required. For this reason, export will accept only one value for the FILE parameter when writing to tape.
Action: Re-enter the EXPORT command, but specify only one tape device in the FILE parameter.
EXP-00077 multiple output files specified for unbounded export file
Cause: You specified multiple file names when doing an export and you also specified a value of 0 for the FILESIZE parameter. Note that 0 is the value used if FILESIZE is not specified on the command line. Since a value of 0 for FILESIZE means that only one file will be written and there is no size limit for that file, the other files you specified in the FILE parameter can never be used.
Action: If you intended to write multiple files, respecify the command but use the FILESIZE to specify the maximum number of bytes that EXPORT should write to each file. If you intended to write only one file with no limits on it's size, reissue the EXPORT command but specify only one file name for the FILE parameter.
EXP-00078 Error exporting metadata for index string. Index creation will be skipped
Cause: Domain indexes export private metadata via anonymous PL/SQL blocks prior to the CREATE INDEX statement. Export does this by calling the ODCIIndexGetMetadata method on the implementation type associated with the index. A problem occurred inside this routine. Because the metadata is considered an integral part of the index, the CREATE INDEX statement was not written to the dump file.
Action: Contact the developer of the index's implementation type. If this is an Oracle-supplied index (perhaps via a data cartridge), contact Oracle Customer Support.
EXP-00079 Data in table "string" is protected. Conventional path may only be exporting partial table.
Cause: User without the execute privilege on DBMS_RLS, the access control package, tries to export a table that has access control. Since table owner is also subjected to access control, the owner may not be able to export all rows in the table, but only the ones he can see. Also, to preserve integrity of the table, user exporting the table should have enough privilege to re-create the table with the security policies at import time. Therefore, it is strongly recommended the database administrator should be handling exporting of this table. Granting the table owner execute privilege would also satisfy this security check, though it might have other security implications. If the table does not have objects, can use direct mode.
Action: Ask the database administrator to export/import this table/view.
EXP-00080 Data in table "string" is protected. Using conventional mode.
Cause: User without the execute privilege on DBMS_RLS, the access control package, tries to direct export a table that has access control enabled. Using conventional export mode instead. Note that because of access control, only a partial table may be exported.
Action: Ask the database administrator to export/import this table/view.
EXP-00081 Exporting access control for table/view "string" as non-DBA.
Cause: A non-DBA user tries to export table/view and the associated fine grain access control policies. The user may not have enough privilege to re-create the access control policies when importing the table/view. And such an event may cause inconsistency in the security model of the table/view.
Action: Ask the database administrator to export/import this table/view.
EXP-00082 Invalid function name passed to procedural object support: string
Cause: Internal inconsistency error: The listed function is not a method on export's procedural object interface specification.
Action: Contact Oracle Customer Support.
EXP-00083 The previous problem occurred when calling string.string.string
Cause: The listed package provides export/import support for procedural actions. The previously listed error occurred while calling the specified function.
Action: Contact Oracle Customer Support. Most packages are supplied by Oracle internal cartridge or server development groups. The package name will help Support determine the correct owner of the problem.
EXP-00084 Unexpected DbmsJava error number at step number
Cause: The error was returned from a call to a DbmsJava procedure.
Action: Record the accompanying messages and report this as an Export internal error to Oracle Customer Support.
EXP-00085 The previous problem occurred when calling string.string.string for object number
Cause: The listed package provides export/import support for procedural objects, i.e., those whose DDL is supplied by stored procedures. The previously listed error occurred while calling the specified function.
Action: Contact Oracle Customer Support. Most packages are supplied by Oracle internal cartridge or server development groups. The package name will help Support determine the correct owner of the problem.
EXP-00086 Primary key REFs in table "string"may not be valid on import
Cause: The specified table contains primary key REFs which may not be valid in the import database.
Action: Do not use Export/Import to move Primary key REFs between databases having differing character sets.
EXP-00087 Problem with internal hash table of schema/table names
Cause: Most likely a problem with allocating memory for the hash table entries.
Action: Contact Oracle Customer Support.
EXP-00089 invalid FILE_FORMAT specification
Cause: The FILE_FORMAT specification did not contain an instance of "string". This wildcard string must be present.
Action: Correct the error and re-enter the EXPORT command.
EXP-00090 view string.string skipped since its definition may be truncated.
Cause: Export was unable to determine if the full text for the view was extracted. To be safe, the view is skipped. This only happens for views whose definition is over 64000 bytes in length.
Action: Export the view manually.
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|