老刘的博客

ALTER TABLE SCHEMA_NAME.TABLE_NAME
  DATA CAPTURE NONE
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;

阅读全文…

删数据很烦人还慢，如果想全部清空又不想重建表，用这个吧
ALTER TABLE SCHEMA.TABLE_NAME ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;