創(chuàng)建臨時(shí)表空間

create temporary tablespace HKDB_DATA
tempfile 'C:\zdc\soft\DateBase\oracle\oracle\oradata\orcl\hkdb_data.dbf' //這個(gè)是在你本地安裝的oracle路徑中創(chuàng)建一個(gè)文件存放表空間數(shù)據(jù)
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  

創(chuàng)建數(shù)據(jù)表空間

create tablespace HKDB_TEMP  
logging  
datafile 'C:\zdc\soft\DateBase\oracle\oracle\oradata\orcl\hkdb_temp.dbf' //這個(gè)是在你本地安裝的oracle路徑中創(chuàng)建一個(gè)文件存放表空間數(shù)據(jù)
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local; 

刪除表空間

DROP TABLESPACE HKDB_DATA INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE HKDB_TEMP INCLUDING CONTENTS AND DATAFILES;