I Created a user with option PASSWORD EXPIRE. Now the problem is that the user is annoyed by entering his password day afer day as it get expired when it cross grace period. I want to disable PASSWORD EXPIRE for that user. How?
i don't think there is any Oracle option as PASSWORD NOT EXPIRE or something like that. Either i have to export the user schema , drop user, again create the user without PASSWORD EXPIRE and then import into this schema. Is there any other easy solution?

Please reply urgently.