cmd> sqlplus / as sysdba
DROP USER eqm CASCADE;
DROP TABLESPACE eqm INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
若報錯「表空間仍被使用」,查詢佔用物件:
SELECT DISTINCT owner, segment_name, segment_type FROM dba_extents WHERE tablespace_name = 'EQM';刪除相關物件後再試。
CREATE TABLESPACE eqm LOGGING DATAFILE 'D:\oracle\product\10.2.0\oradata\EQM.DBF' SIZE 4096M AUTOEXTEND ON NEXT 150M MAXSIZE 20480M EXTENT MANAGEMENT LOCAL;
CREATE USER eqm IDENTIFIED BY eqm DEFAULT TABLESPACE eqm;
GRANT DBA TO eqm;
CASCADE:級聯刪除用戶所有物件。INCLUDING CONTENTS AND DATAFILES:連同段與資料檔一併刪除。CASCADE CONSTRAINTS:同時刪除引用該表空間表的外鍵。AUTOEXTEND ON NEXT ... MAXSIZE:自動擴展,避免滿檔案中斷。EXTENT MANAGEMENT LOCAL:本地管理,效能優於字典管理。