Yesterday, a friend of mine asked me about an error he was getting while running a schema level export in Oracle 8i:
exp system/manager@DB owner=ABC file=ABC.dmp log =ABC.log Export: Release 8.1.7.1.0 - Production on Fri Nov 12 04:21:05 2010 (c) Copyright 2000 Oracle Corporation. All rights reserved. EXP-00056: ORACLE error 28002 encountered ORA-28002: the password will expire within 11 days EXP-00056: ORACLE error 24309 encountered ORA-24309: already connected to a server EXP-00000: Export terminated unsuccessfully
I googled and metalink’ed (oops…is there anything like that ? 😉 ) a bit and found that it was bug 1654141 where user accounts in grace period cannot perform export. It is fixed in Oracle 9i (version 9.0.0.0 as per metalink). The obvious work around is to change the password and then try again. Thought about posting it here so that Google can give little better results if someone in trouble comes searching for it ;).
wonderful man !
but what is the criterian for the error i mean how many days before it expire .. i guess it has sometihng to do password policy ? is it so ?
Yes, password policy.
When a user’s grace period (the password is expired but the DBA has set a grace period of x number of days, so user would be able to login for those many days, he will get a message about the expired password, though) is going on, he cannot perform the export.