10 Replies Latest reply: Oct 30, 2013 1:29 PM by TSharma-Oracle RSS

    How to extend temp tablesspace.

      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 ?