Oracle

Oracle workaround

Дублирование sequence

Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

Удаление sequence:

DROP SEQUENCE ids_sequence;

Закончился срок действия пароля

ORA-28001: the password has expired
SELECT * FROM dba_profiles;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE '%EXPIRED%';
ALTER USER "SYSTEM" IDENTIFIED BY "SYSTEM"; 
ALTER USER "SYSTEM" ACCOUNT UNLOCK;
Читать...