数据库无法修改与非键值保存表对应的列
SQL> select * from dba_users;
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP EXTERNAL_NAME
------------------------------ ---------- ------------------------------ -------------------------------- ----------- ----------- ------------------------------ ------------------------------ ----------- ------------------------------ ------------------------------ --------------------------------------------
MGMT_VIEW 53 F25A184809D6458D OPEN SYSTEM TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
SYS 0 8F496E0A85640576 OPEN SYSTEM TEMP 2005/8/30 1 DEFAULT SYS_GROUP
SYSTEM 5 E7992808912AB2CF OPEN SYSTEM TEMP 2005/8/30 1 DEFAULT SYS_GROUP
DBSNMP 24 E6E9AD214F9DEFFE OPEN SYSAUX TEMP 2005/8/30 1 MONITORING_PROFILE DEFAULT_CONSUMER_GROUP
SYSMAN 51 17F2F68A0543EC8B OPEN SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
SCOTT 54 F894844C34402B67 OPEN USERS TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
MYHR_TEST 64 356CEC11544EBE9A OPEN USERS TEMP 2013/8/10 2 DEFAULT DEFAULT_CONSUMER_GROUP
USER1 61 F6D32AC5D94923CC OPEN USERS TEMP 2013/8/10 1 DEFAULT DEFAULT_CONSUMER_GROUP
MYHR 63 095FD9362D21DD4E OPEN USERS TEMP 2013/8/10 2 DEFAULT DEFAULT_CONSUMER_GROUP
OUTLN 11 4A3BA55E08595C81 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSTEM TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
MDSYS 46 72979A94BAD2AF80 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
ORDSYS 43 7EFA02EC7EA6B86F EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
EXFSYS 34 66F4EF5650C20355 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
DMSYS 35 BFBA5A553FD9E28A EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
WMSYS 25 7C9BA362F8314299 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
CTXSYS 36 71E687F036AD56E5 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
ANONYMOUS 39 anonymous EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
XDB 38 88D8364765FCE6AF EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
ORDPLUGINS 44 88A2B2C183431F00 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
SI_INFORMTN_SCHEMA 45 84B8CBCA4D477FA3 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP EXTERNAL_NAME
------------------------------ ---------- ------------------------------ -------------------------------- ----------- ----------- ------------------------------ ------------------------------ ----------- ------------------------------ ------------------------------ --------------------------------------------
OLAPSYS 47 3FB8EF9DB538647C EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 SYSAUX TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
TSMSYS 21 3DF26A8B17D0F29F EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 USERS TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
BI 60 FA1D2B85B70213F3 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 USERS TEMP 2013/8/7 12 DEFAULT DEFAULT_CONSUMER_GROUP
PM 59 72E382A52E89575A EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 USERS TEMP 2013/8/7 12 DEFAULT DEFAULT_CONSUMER_GROUP
MDDATA 50 DF02A496267DEE66 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 USERS TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
IX 57 2BE6F80744E08FEB EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 USERS TEMP 2013/8/7 12 DEFAULT DEFAULT_CONSUMER_GROUP
SH 58 9793B3777CD3BD1A EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 USERS TEMP 2013/8/7 12 DEFAULT DEFAULT_CONSUMER_GROUP
DIP 19 CE4A36B8E06CA59C EXPIRED & LOCKED 2013/8/7 15 USERS TEMP 2005/8/30 1 DEFAULT DEFAULT_CONSUMER_GROUP
OE 56 9C30855E7E0CB02D EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 USERS TEMP 2013/8/7 12 DEFAULT DEFAULT_CONSUMER_GROUP
HR 55 6399F3B38EDF3288 EXPIRED & LOCKED 2013/8/7 15 2013/8/7 12 USERS TEMP 2013/8/7 12 DEFAULT DEFAULT_CONSUMER_GROUP
30 rows selected
SQL> update dba_users set username='myhr1' where username='myhr_test';
update dba_users set username='myhr1' where username='myhr_test'
ORA-01779: 无法修改与非键值保存表对应的列
请问是怎么回事~
------解决方案--------------------
很奇怪，你更新一张表 怎么会 check出来的
一般这个错误 都是你好几张表一起关联更新的时候 有多条记录才会有
/*+ BYPASS_UJVC */ 你用这个方法试试
update /*+ BYPASS_UJVC */dba_users set username='myhr1' where username='myhr_test';
在前面还是后面 忘记了。。。 好像是屏蔽这个check的
