database link password expire

[Gerhardus S]

I'm queering a database over a dblink

select sysdate from dual@remotedb

I get ORA-28002 "The password will expire within X days", no mater if I click OK or Cancel I still don't get the results.

Is there a way that I can disable this warning and get to see my data?

 

[Marco Kalter]

Unfortunately the Oracle Server treats this as an error when accessing a database link, instead of a warning like when you are really logging on. I'm not sure if there is a solution other than setting the password.