My Oracle Support Banner

DataPump API Fails With Errors ORA-39232 Invalid Remap Function And ORA-39012 Client Detached (Doc ID 879153.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.1]
Information in this document applies to any platform.
NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

The following object names are sample/fictious data used in this example to describe the problem:

User Name: TEST
Table Name: UDF_VAL_TEST


When using DataPump API the following errors are received:

ORA-39232: invalid remap function: NewUDFValExt
ORA-39012: Client detached before the job started.

Please note that the function name will be replaced with your defined function name. In our example it is 'NewUDFValExt'.


Test to reproduce:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.