create tempfile

1.

　

　

create TEMPORARY TABLESPACE TEMP3 TEMPFILE '/uatdb/app/oradata/temp001.dbf' size 5000M;

Tablespace created.

　

2.

　

ALTER TABLESPACE TEMP3 ADD TEMPFILE '/uatdb/app/oradata/temp002.dbf' SIZE 5000m;

Tablespace created.

　

3.

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp3;

　

4.

drop tablespace temp1 including contents and datafiles;