Export fails with error UDE-00002: invalid username or password :

UDE-00002
While taking export backup in Oracle Database, sometimes we may encounter the error : UDE-00002: invalid username or password. Today we will discuss how to resolve this.

Table of Contents

Error :

oracle@testserver1:/oradata01/test/export>expdp parfile=testing.par

Export: Release 10.2.0.3.0 - 64bit Test on Friday, 28 August, 2020 21:37:31

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Username: /as sysdba
UDE-00002: invalid username or password

Solution :

Use the correct password of sys, if still not working , issue the below command, it will go fine this time.


expdp \'/ as sysdba\' parfile=testing.par

Otherwise, take export from the system or another user.

So, here you got that makes you export task easier. Hope this helps!! Also, you can get the reference from below link for all these type of UDEs.

UDE-00001 to UDE-00054

Our other ORA Error Related Articles :

Leave a Reply