Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXP-00010: xxxx is not a valid username

775855Dec 5 2011 — edited Dec 5 2011

Hi

I am doing an export of 6MB of schema in database 10g on SUN Solaris OS. But I am facing an error

EXP-00010 is not a valid username, even though that user exist. I thought it could be the reason because the account is locked and expired. But after changing to OPEN state also i am getting the same error. Below is the details

pidcpdev:/export/home/oracle>exp \'/ as sysdba \' file=wmsys_exp_061211.dmp log=wmsys_exp_061211.log owner=WMSYS statistics=none

Export: Release 10.2.0.3.0 - Production on Mon Dec 5 16:30:42 2011

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

Connected to: Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
EXP-00010: WMSYS is not a valid username
Export terminated successfully with warnings.
pidcpdev:/export/home/oracle>

=====================================

SQL> select username from dba_users where username='WMSYS';

USERNAME
------------------------------
WMSYS

=============================================

What could be the reason ?

Thanks
Shiyas M