42537488 条record的table,truncate需要多长时间?
这个table占用了很多数据库空间,执行truncate可以释放空间吗?
USER_D01 TABLE PARTITION 38
USER_D01 TABLE PARTITION 38
USER_D01 TABLE PARTITION 38
USER_D01 TABLE PARTITION 38
USER_D01 TABLE PARTITION 38
USER_D01 TABLE PARTITION 38
USER_D01 TABLE PARTITION 38
USER_D01 TABLE PARTITION 38
USER_D01 TABLE PARTITION 38
USER_D01 TABLE PARTITION 38
。。。。。。
/data2/DB1/b_d03_01.dbf 31,457,280K 31,442,944K 14,336K
/data2/DB1/b_d03_02.dbf 31,457,280K 31,442,944K 14,336K
/data2/DB1/b_d03_03.dbf 31,457,280K 31,424,512K 32,768K
/data2/DB1/b_d03_04.dbf 31,457,280K 31,436,800K 20,480K
/data2/DB1/b_d03_05.dbf 31,457,280K 31,451,136K 6,144K
/data2/DB1/b_d03_06.dbf 31,457,280K 31,449,088K 8,192K
/data2/DB1/b_d03_07.dbf 31,457,280K 31,449,088K 8,192K
/data2/DB1/b_d03_08.dbf 31,457,280K 31,447,040K 10,240K
/data2/DB1/b_d03_09.dbf 31,457,280K 31,305,728K 151,552K
/data2/DB2/b_d03_10.dbf 31,457,280K 31,449,088K 8,192K
/data2/DB2/b_d03_11.dbf 31,457,280K 31,455,232K 2,048K
/data2/DB2/b_d03_12.dbf 31,457,280K 21,225,472K 10,231,808K
/data1/DB2/b_d03_14.dbf 31,457,280K K K
/data1/DB2/b_d03_15.dbf 31,457,280K K K
/data1/DB2/b_d01_04.dbf 20,971,520K K K
/data1/DB2/b_d03_16.dbf 31,457,280K K K
/data1/DB2/b_d03_17.dbf 31,457,280K K K
/data1/DB2/b_d03_18.dbf 31,457,280K 22,654,976K 8,802,304K
/data1/DB2/b_d03_19.dbf 31,457,280K 22,521,856K 8,935,424K
/data1/DB2/b_d03_20.dbf 10,485,760K K K