Skip to Main Content
Forums

Oracle Database Discussions

Announcement

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!

Add temp space to temp tablespace

2670775Mar 9 2016 — edited Mar 10 2016

SQL> set linesize 1000;
SQL> select tablespace_name,file_name,bytes from dba_temp_files;

TABLESPACE_NAME                FILE_NAME                                                                                                                                     BYTES
------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
TEMP01                         /u01/data/oraclesid/temp01.272.818720451                                                                                                1609564160

SQL>

I have a temp tablespace call TEMP01. and How to extend the tablespace?

1. extend the datafile

2.  or add one more datafile ??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2016
Added on Mar 9 2016
#general-database-discussions
9 comments
4,157 views