Oracle Database Errors or Warnings from Error ORA-39189 to ORA-39205

SQLServerF1

ORA-39189: unable to decrypt dump file set
Cause: The dump file set could not be decrypted. The reason could be either that an invalid password was entered, or that, when using transparent decryption, the database external security device was not open.
Action: If password-based import was enabled for this dump file set, then supply the correct password. If transparent import was enabled for this dump file set, then ensure that the database external security device is open.
ORA-39190: internal error occurred during encryption phase string
Cause: An unexpected error occurred while encrypting data buffers.
Action: See the secondary error for more information and contact Oracle Customer Support.
ORA-39191: internal error ocurred during decryption phase string
Cause: An unexpected error occurred while decrypting data buffers.
Action: See the secondary error for more information and contact Oracle Customer Support.

ORA-39192: table mode jobs with transportable=always and partition filters only allow objects from one table
Cause: Multiple tables are not supported when specifying partitions while using transportable table mode.
Action: Retry the job specifying only one table.
ORA-39200: Link name “string” is invalid.
Cause: The name of the network link supplied for a Data Pump job was not usable. Secondary messages identify the problem.
Action: Rerun the job using a valid network link.
ORA-39201: Dump files are not supported for estimate only jobs.
Cause: An attempt was made to add a dumpfile to an Export job that only requested file estimates.
Action: Do not specify a dumpfile for jobs that do not require dumpfiles.

ORA-39202: Data cannot be filtered or selected in string jobs.
Cause: A data filter was supplied for the specified type of job, but is not supported in the specified job type. From the command line, data filters can be specified by the CONTENT, TABLES (partition specifications), SAMPLE and QUERY parameters.
Action: Do not restrict data handling on jobs that cannot support data filtering.
ORA-39203: Partition selection is not supported over a network link.
Cause: Specific partitions were selected for a job operating over a network link.
Action: Remove the partition specifications and rerun the job.
ORA-39204: No subsetting of tablespaces is allowed for transportable import.
Cause: A tablespace filter was applied to a transportable import job that was not performed over a network link. In this case, the tablespace may not be changed from its specification at export time.
Action: Rerun the job without specifying a tablespace filter.
ORA-39205: Transforms are not supported in transportable jobs.
Cause: A metadata transformation such as STORAGE or SEGMENT_ATTRIBUTES has been specified for a transportable Data Pump job.
Action: Rerun the job without specifying a transform.

Above are list of Oracle Database Errors or Warnings from Error ORA-39189 to ORA-39205 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 *