recreate temp tbs.txt

来自「Oracle培训专题3-数据库配置.ppt Oracle培训专题4-备份和恢复」· 文本 代码 · 共 22 行

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