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"
posts - 66, comments - 12, trackbacks - 0, articles - 0 |
|
CREATE SMALLFILE TEMPORARY TABLESPACE "TempTableName" TEMPFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TempTableName ' SIZE 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M |
|