how to add a datafile in the temp tablespace
441475Jul 14 2006 — edited Jul 15 2006how i can add a datafile in the temp tablespace.
becuase i am getting tyhe following error
SQL> select aa.question_desc,a.answer_desc from answer a ,
2 (select * from question_t where rownum <=100 order by dbms_random.random) aa
3 where a.question_id = aa.question_id
4 /
select aa.question_desc,a.answer_desc from answer a ,
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 256 in tablespace TEMP