"Ora-02000: missing EXPIRE keyword" error when trying to create user in another database. (55882)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

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

Feedback submitted.

Was this article helpful?

[Select Rating]

Title