Posted on 2008-05-28 11:39
cyantide 阅读(506)
评论(0) 编辑 收藏 所属分类:
数据库相关
CREATE SMALLFILE TEMPORARY TABLESPACE "TempTableName" TEMPFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TempTableName ' SIZE 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TempTableName"