- SQL> exec dbms_stats.gather_table_stats(ownname => 'testtemp',tabname => 'record_partition',degree => 3);
-
- PL/SQL procedure successfully completed
-
- SQL> select table_name,partition_name,num_rows FROM user_tab_partitions order by 1,2;
-
-
TABLE_NAME PARTITION_NAME NUM_ROWS
------------------------------ ------------------------------ ----------
RECORD_INDEX PART_011 7055568
RECORD_INDEX PART_012 5231180
RECORD_INDEX PART_013 8568201
RECORD_PARTITION PART01_2013 99986
RECORD_PARTITION PART02_2014 0
RECORD_PARTITION PART03_2015 0
RECORD_PARTITION PART04_2016 13
RECORD_PARTITION_HASH PART01
RECORD_PARTITION_HASH PART02
RECORD_PARTITION_HASH PART03
RECORD_PARTITION_HASH PART04
11 rows selected - SQL> alter table record_partition truncate partition PART01_2013;
-
- Table truncated
-
- SQL> exec dbms_stats.gather_table_stats(ownname => 'testtemp',tabname => 'record_partition',degree => 3);
-
- PL/SQL procedure successfully completed
-
- SQL> select count(*) from RECORD_PARTITION;
-
- COUNT(*)
- ----------
- 13
- SQL> alter table record_partition truncate partition PART04_2016;
-
- Table truncated
-
- SQL> exec dbms_stats.gather_table_stats(ownname => 'testtemp',tabname => 'record_partition',degree => 3);
-
- PL/SQL procedure successfully completed
-
- SQL> insert /*+ append */ into record_partition select * from record ;
-
- insert /*+ append */ into record_partition select * from record
-
- ORA-26026: 唯一的索引 TESTTEMP.SYS_C0035273 最初处于无法使用的状态
-
- SQL>
- SQL>
点击(此处)折叠或打开
- SQL> alter index TESTTEMP.SYS_C0035273 rebuild online;
-
- Index altered