Return
-
Title
"Ora-02000: missing EXPIRE keyword" error when trying to create user in another database. -
Description
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".
-
Resolution
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. -
Defect ID
ST65043