recreate temp tbs.txt

Oracle培训专题3-数据库配置.ppt Oracle培训专题4-备份和恢复.ppt Oracle培训专题5-浅谈调优.ppt

CREATE 
    TEMPORARY TABLESPACE "TEMP01" TEMPFILE 
    'D:\ORACLE\ORADATA\MY9IDB\TEMP01.ora' 
    SIZE 200M
    reuse
    
ALTER USER "ZHT"  
    TEMPORARY TABLESPACE "TEMP01"

DROP TABLESPACE "HSCMPTEMP" INCLUDING CONTENTS


CREATE 
    TEMPORARY TABLESPACE "HSCMPTEMP" TEMPFILE 
    'D:\ORACLE\ORADATA\MY9IDB\HSCMPTEMP.ora' 
    SIZE 200M
    reuse
    
ALTER USER "ZHT"  
    TEMPORARY TABLESPACE "HSCMPTEMP"

DROP TABLESPACE "TEMP01" INCLUDING CONTENTS