This discussion is archived
10 Replies Latest reply: Oct 30, 2013 11:29 AM by TSharma-Oracle RSS

How to extend temp tablesspace.

Newbie
Currently Being Moderated

I was asked to extend temp tablespace.

 

Is it OK by below ?

 

  SQL> alter database tempfile 'temp_file_path' resize filesize;

  Example

  SQL> alter database tempfile '/data/temp01.dbf' resize 200M;


Is there any caution to extend temp tablespace ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points