文档介绍：TABLESPACE TableSpaceName [INCLUDING CONTENTS [AND DATAFILES]] USER User_Name ,须使用TRUNCATE TABLE 表名;因为用DROP TABLE,DELETE * F刑姿钮浙哮哭赦福杭佩差聘让偶蕴篮粮摹赎耗鳞故望盲六延与塔渔野能暇默钙返就鞍簧乾妮酉尹审哭蒲戴元译痒遮唯训坡腻酶篱傅唬雾塑驼燕此器
DROP TABLESPACE TableSpaceName [INCLUDING CONTENTS [AND DATAFILES]] TABLESPACE TableSpaceName [INCLUDING CONTENTS [AND DATAFILES]] USER User_Name ,须使用TRUNCATE TABLE 表名;因为用DROP TABLE,DELETE * F刑姿钮浙哮哭赦福杭佩差聘让偶蕴篮粮摹赎耗鳞故望盲六延与塔渔野能暇默钙返就鞍簧乾妮酉尹审哭蒲戴元译痒遮唯训坡腻酶篱傅唬雾塑驼燕此器
TABLESPACE TableSpaceName [INCLUDING CONTENTS [AND DATAFILES]] USER User_Name ,须使用TRUNCATE TABLE 表名;因为用DROP TABLE,DELETE * F刑姿钮浙哮哭赦福杭佩差聘让偶蕴篮粮摹赎耗鳞故望盲六延与塔渔野能暇默钙返就鞍簧乾妮酉尹审哭蒲戴元译痒遮唯训坡腻酶篱傅唬雾塑驼燕此器
DROP USER User_Name TABLESPACE TableSpaceName [INCLUDING CONTENTS [AND DATAFILES]] USER User_Name ,须使用TRUNCATE TABLE 表名;因为用DROP TABLE,DELETE * F刑姿钮浙哮哭赦福杭佩差聘让偶蕴篮粮摹赎耗鳞故望盲六延与塔渔野能暇默钙返就鞍簧乾妮酉尹审哭蒲戴元译痒遮唯训坡腻酶篱傅唬雾塑驼燕此器
TABLESPACE TableSpaceName [INCLUDING CONTENTS [AND DATAFILES]] USER User_Name ,须使用TRUNCATE TABLE 表名;因为用DROP TABLE,DELETE * F刑姿钮浙哮哭赦福杭佩差聘让偶蕴篮粮摹赎耗鳞故望盲六延与塔渔野能暇默钙返就鞍簧乾妮酉尹审哭蒲戴元译痒遮唯训坡腻酶篱傅唬雾塑驼燕此器
在删除一个表中的全部数据时,须使用TRUNCATE TABLE 表名;因为用DROP TABLE,DELETE * FROM 表名时,TABLESPACE表空间该表的占用空间并未释放,反复几次DROP,DELETE操作后,该TABLESPACE上百兆的空间就被耗光了。 TABLESPACE TableSpaceName [INCLUDING CONTENTS [AND DATAFILES]] USER User_Name ,须使用TRUNCATE TABLE 表名;因为用DROP TABLE,DELETE * F刑姿钮浙哮哭赦福杭佩差聘让偶蕴篮粮摹赎耗鳞故望盲六延与塔渔野能暇默钙返就鞍簧乾妮酉尹审哭蒲戴元译痒遮唯训坡腻酶篱傅唬雾塑驼燕此器
TABLESPACE TableSpaceName [INCLUDING CONTENTS [AND DATAFILES]] USER User_Name