My Oracle Support Banner

"ORA-31684: Object type PASSWORD_VERIFY_FUNCTION:"xxxxx" already exists" Error When Executing Data Pump Import Containing Password Verify Function Objects (Doc ID 2594630.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

When importing a password verify function and multiple profiles reference the function, an ORA-31684 error occurs for each profile that references the function:

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 -
64bit Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** directory=dpump_dir
dumpfile=test_pw_ver_func.dmp parallel=1
Processing object type DATABASE_EXPORT/PASSWORD_VERIFY_FUNCTION
ORA-31684: Object type PASSWORD_VERIFY_FUNCTION:"SYS"."TEST_DB_VERIFY_FUNCT"
already exists

ORA-31684: Object type PASSWORD_VERIFY_FUNCTION:"SYS"."TEST_DB_VERIFY_FUNCT"
already exists

ORA-31684: Object type PASSWORD_VERIFY_FUNCTION:"SYS"."TEST_DB_VERIFY_FUNCT"
already exists

ORA-31684: Object type PASSWORD_VERIFY_FUNCTION:"SYS"."TEST_DB_VERIFY_FUNCT"
already exists

Processing object type DATABASE_EXPORT/PROFILE
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 4 error(s) at Tue Dec 18
13:46:18 2018 elapsed 0 00:00:04

This occurs even when the fix for Bug 28539085 is applied.

Cause

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
Symptoms
Cause
Solution
References


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