Oracle Database Errors or Warnings from Error ORA-39156 to ORA-39166

SQLServerF1

ORA-39156: error parsing dump file name “string”
Cause: Export was unable to parse the dump file name. Subsequent messages will detail the problems.
Action: Fix the problems outlined in the secondary messages.
ORA-39157: error appending extension to file “string”
Cause: Export or Import was unable to append the default extension to create the file name. The given file name could be too long or contain illegal characters. Subsequent messages will detail the problems.
Action: Fix the problems outlined in the secondary messages.
ORA-39159: cannot call this function from a non-Data Pump process
Cause: Called a Data Pump process model function from a process which is not a Data Pump process.
Action: Refer to any other error messages for additional information. If this error occurs from a Data Pump client (e.g. expdp or impdp), try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.

ORA-39160: error on whats my name call
Cause: Attempt to get the Data Pump process name failed.
Action: Refer to any following error messages for additional information. If this error occurs from a Data Pump client (e.g. expdp or impdp), try the operation again. If the error occurs again, contact Oracle Customer Support and report the error.
ORA-39161: Full database jobs require privileges
Cause: Either an attempt to perform a full database export without the EXP_FULL_DATABASE role or an attempt to perform a full database import over a network link without the IMP_FULL_DATABASE role.
Action: Retry the operation in a schema that has the required roles.
ORA-39162: Transportable tablespace job require privileges
Cause: User attempted to perform a transportable tablespace job without being having the proper EXP_FULL_DATABASE or IMP_FULL_DATABASE role.
Action: Retry the operation in a schema that has the required roles.

ORA-39163: A sample size of string is invalid.
Cause: An attempt was made to do data sampling on a table with a value outside of the range of 0 – 100.
Action: Retry the filtering using a sampling number greater than 0 and less than 100.
ORA-39164: Partition string was not found.
Cause: If exporting or importing over the network, the user specified a partition name that was not found in the source database. For importing from files, the user specified a partition name not found in the dump file set.
Action: Retry the operation using the correct partition name.
ORA-39165: Schema string was not found.
Cause: If exporting or importing over the network, either the user specified a schema name that was not found in the source database or else the user lacked the proper EXP_FULL_DATABASE or IMP_FULL_DATABASE role that would allow them to access another schema. For importing from files, the user specified a schema name not found in the dump file set.
Action: Retry the operation using the correct schema name.
ORA-39166: Object string was not found.
Cause: If exporting or importing over the network, either the user specified an object name that was not found in the source database or else the user lacked the proper EXP_FULL_DATABASE or IMP_FULL_DATABASE role that would allow them to access the object another in another schema. For importing from files, the user specified an object name not found in the dump file set.
Action: Retry the operation using the correct object name.

Above are list of Oracle Database Errors or Warnings from Error ORA-39156 to ORA-39166 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *