SQL>
SQL> create table test_part(id number(10),name varchar2(100),cdate date)
2 partition by range(cdate)
3
SQL>
SQL> create table test_part(id number(10),name varchar2(100))
2 partition by range(id)
3 (partition p1 values less than(10),
4 partition p2 values less than(20),
5 partition p3 values less than(30)
6 );
Table created.
SQL> insert into test_part values(1,'aa');
1 row created.
SQL> insert into test_part values(15,'bb');
1 row created.
SQL> insert into test_part values(25,'cc');
1 row created.
SQL> commit;
Commit complete.
SQL> update test_part set id=9 where id=15;
update test_part set id=9 where id=15
*
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change
SQL> alter table test_part enable row movement;
Table altered.
SQL> update test_part set id=9 where id=15;
1 row updated.
SQL> commit;
Commit complete.
阅读(1376) | 评论(0) | 转发(0) |