Refer to the following link for further information.
http://download.oracle.com/docs/cd/B14117_01/server.101/b10739/omf.htm
To add temp files, do the following:
alter system set db_create_file_dest='...' scope = both;
create temporary tablespace temp_01 tempfile size 1000m;
4096 Columns
3 weeks ago