如何删除大表

alter table test modify(REPLYMSG) (DEALLOCATE UNUSED KEEP 10m);

alter table t set unused column x
alter table t drop unused columns checkpoint 500;


 SQL> TRUNCATE TABLE BIGTAB REUSE STORAGE;
   2. If it takes 3 days (72 hours) to drop the table, spread this out over
      6 nights i.e. drop 1/3 Gb per night. This can be achieved in 6 (nightly)
      steps as follows:
      Night 1: 
        SQL> ALTER TABLE BIGTAB DEALLOCATE UNUSED KEEP 1707M; (2Gb*5/6)
      Night 2: 
        SQL> ALTER TABLE BIGTAB DEALLOCATE UNUSED KEEP 1365M; (2Gb*4/6)
      Night 3: 
        SQL> ALTER TABLE BIGTAB DEALLOCATE UNUSED KEEP 1024M; (2Gb*3/6)
      Night 4: 
        SQL> ALTER TABLE BIGTAB DEALLOCATE UNUSED KEEP 683M; (2Gb*2/6)
      Night 5: 
        SQL> ALTER TABLE BIGTAB DEALLOCATE UNUSED KEEP 341M; (2Gb*1/6)
      Night 6: 
        SQL> DROP TABLE BIGTAB;


   The same method can be applied if LOB segments or indexes are involved.


        SQL> ALTER TABLE <table_name> MODIFY LOB (<lob_column>)
             DEALLOCATE UNUSED KEEP <value>M;
 SQL> ALTER INDEX <index_name> DEALLOCATE UNUSED KEEP <value>M;
 


        SQL> ALTER INDEX <index_name> DEALLOCATE UNUSED KEEP <value>M;