I need a syntax to create a temporary tablespace with locally managed and uniform extent size.
Printable View
I need a syntax to create a temporary tablespace with locally managed and uniform extent size.
CREATE TEMPORARY TABLESPACE "MY_TEMP" TEMPFILE
'E:\oracle\ORADATA\TEST\my_tmp.dbf'
SIZE 150M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
http://download-west.oracle.com/docs...5e.htm#2063487