SQL> Select MailID,TotalSize,Content from emailrecvmsg where MailID='0304260742B000071801';
SP2-0678: Column or attribute type can not be displayed by SQL*Plus
SQL> Insert into emailrecvmsgBak (Select MailID,TotalSize,Content from emailrecvmsg where MailID='0304260742B000071801');
Insert into emailrecvmsgBak (Select MailID,TotalSize,Content from emailrecvmsg where MailID='0304260742B000071801')
*
ERROR at line 1:
ORA-01555: snapshot too old: rollback segment numberwith name "" too small
ORA-22924: snapshot too old
请问那位知道它的原理,以及应该如何结局阿?我的表中由long字段。
|