エラー対応
[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];
指定されたパートは存在しません。
YAGI Hiroto (piroto@a-net.email.ne.jp)
twitter http://twitter.com/pppiroto
Copyright© 矢木 浩人 All Rights Reserved.