- 追加された行はこのように表示されます。
- 削除された行は
このように表示されます。
!!!エラー対応
[Oracle]
!!エラー内容を確認するコマンド oerr
$ oerr ora 1031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary operating
// system privileges.
// When Trusted Oracle is configure in DBMS MAC, this error may occur
// if the user was granted the necessary privilege at a higher label
// than the current login.
// *Action: Ask the database administrator to perform the operation or grant
// the required privileges.
// For Trusted Oracle users getting this error although granted the
// the appropriate privilege at a higher label, ask the database
// administrator to regrant the privilege at the appropriate label.
!!対応
::ORA-00988: missing or invalid password(s)
*数字で始まるパスワードの場合、ダブルクォーテーションで囲む
::ORA-01950: 表領域'XXXXX'に対する権限がありません
ALTER USER [USERNAME]
QUOTA UNLIMITED ON [TABLESPACE_NAME];
----
{{include_html banner_html, "!Oracle"}}