"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 laterInformation 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
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 |