12,673
回編集
差分
ナビゲーションに移動
検索に移動
編集の要約なし
===エラー内容を確認するコマンド oerr===
$ oerr ora 1031
01031, 00000, "insufficient privilegespri[[vi]]leges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilegepri[[vi]]lege. This error also occurs if
// attempting to install a database without the necessary operating
// system privilegespri[[vi]]leges. // When Trusted [[Oracle ]] is configure in DBMS MAC, this error may occur // if the user was granted the necessary privilege pri[[vi]]lege at a higher label
// than the current login.
// *Action: Ask the database administrator to perform the operation or grant
// the required privilegespri[[vi]]leges. // For Trusted [[Oracle ]] users getting this error although granted the // the appropriate privilege pri[[vi]]lege at a higher label, ask the database // administrator to regrant the privilege pri[[vi]]lege at the appropriate label.
===対応===
=====ORAO[[R]]A-00988: missing or invalid password(s)=====
*数字で始まるパスワードの場合、ダブルクォーテーションで囲む
=====ORAO[[R]]A-01950: 表領域'XXXXX'に対する権限がありません=====
ALTER USER [USERNAME]
QUOTA UNLIMITED ON [TABLESPACE_NAME];
----
{{include_html [[banner_html]], "!Oracle"}}
© 2006 矢木浩人
