ORA-14402 更新分區關鍵字列

來源:互聯網
上載者:User

為瞭解決這個問題,可以使用如下命令更改分區表的屬性:

SQL> alter table DOM_REAL_CATEGORY_FL enable row movement;

Table altered.

更改分區表的分區索引值,意味著要刪除記錄並重新插入一條新的記錄,這會引起記錄(Record)的移動,記錄的Rowid會改變,相關索引需要進行維護。

SQL> update DOM_REAL_CATEGORY_FL set doc_level=101 where doc_level=51;

57024 rows updated.

Elapsed: 00:00:34.61

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.