When trying to use the "Create in another database" feature to create a user from one database in another, An error appers indicating "Ora-02000: missing EXPIRE keyword".
WORKAROUND
Manually edit the SQL that Toad creates. One must change the 'IDENTIFIED BY <password>' line to 'IDENTIFIED BY VALUES 'password'', where 'password' is the password you want to use.
STATUS
Waiting for issue to be resolved in a future version of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy