result.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

SET ECHO      ON;                                                                                                                                                                                                                                              
drop user dyt cascade;                                                                                                                                                                                                                                         
drop tablespace HISTORY01 INCLUDING CONTENTS;                                                                                                                                                                                                                  
drop tablespace HISTORY02 INCLUDING CONTENTS;                                                                                                                                                                                                                  
drop tablespace ROAMUSER130 INCLUDING CONTENTS;                                                                                                                                                                                                                
drop tablespace ROAMUSER131 INCLUDING CONTENTS;                                                                                                                                                                                                                
drop tablespace ROAMUSER133 INCLUDING CONTENTS;                                                                                                                                                                                                                
drop tablespace ROAMUSER135 INCLUDING CONTENTS;                                                                                                                                                                                                                
drop tablespace ROAMUSER136 INCLUDING CONTENTS;                                                                                                                                                                                                                
drop tablespace ROAMUSER137 INCLUDING CONTENTS;                                                                                                                                                                                                                
drop tablespace ROAMUSER138 INCLUDING CONTENTS;                                                                                                                                                                                                                
drop tablespace ROAMUSER139 INCLUDING CONTENTS;                                                                                                                                                                                                                
drop tablespace ROAMUSERXXX INCLUDING CONTENTS;                                                                                                                                                                                                                
drop tablespace STAT01 INCLUDING CONTENTS;                                                                                                                                                                                                                     
drop tablespace STAT02 INCLUDING CONTENTS;                                                                                                                                                                                                                     
drop tablespace STAT03 INCLUDING CONTENTS;                                                                                                                                                                                                                     
drop tablespace STAT04 INCLUDING CONTENTS;                                                                                                                                                                                                                     
quit;