如果删除记录多,保留记录少的话,泥可以这样: 1、CREATE TABLE AS SELECT * FROM TAB WHERE [保留记录的条件];2、DROP TABLE TAB;
If this is not a Locally Managed TS, try: SQL> alter tablespace tablespace_name storage (pctincrease 1) SQL> alter tablespace tablespace_name coalesce SQL> alter tabelspace tablespace_name storage (pctincrease 0)
SQL>
1、CREATE TABLE AS
SELECT * FROM TAB WHERE [保留记录的条件];2、DROP TABLE TAB;