压测数据删除

deleteptestdata.sh:

sqlplus dbuser/pwd <<EOF >deleteptestdata.log
@deleteptestdata.sql
exit
EOF

--某个表处理:
alter session enable parallel dml;
alter table dbuser.passwd  nologging;
delete /*+ PARALLEL(t1,4) */ from  dbuser.passwd t1 where id like '20451477%';
commit;

alter table dbuser.dbname  logging;

--释放表空间
alter table tablename enable row movement ;
ALTER TABLE tablename SHRINK SPACE COMPACT;
ALTER TABLE tablename SHRINK SPACE cascade;

commit;