oracle11g Create, delete, tablespace statements __oracle

Remove tablespace
drop tablespace POSP including CONTENTS and datafiles;

/divided into four steps/

/* 1th step: Create temporary table space  * *
temporary tablespace posp_temp 
tempfile ' F:\oracle\oracle-data\posp_temp.dbf ' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;    

/* 2nd step: Create datasheet Space  * *
tablespace POSP
logging  
datafile ' F:\oracle\oracle-data\posp_data.dbf ' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  

/* 3rd step: Create user and specify table space */create username
Posp identified by Posp
default tablespace posp
Temporary Tablespace posp_temp;

/* Step 4th: Grant permissions to the user/grant
connect,resource,dba to Posp

Reference:
Create tablespace:
https://www.cnblogs.com/wangsaiming/p/3555994.html
Processing of ora-01119 and ora-27040 when creating tablespaces:
https://www.cnblogs.com/gaojian/p/3612845.html
Oracle deletes users and tablespaces:
http://blog.csdn.net/oscar999/article/ details/7468153