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.
Our other ORA Error Related Articles :
