For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
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 ?