Ora-01652 : Unable To Extend Temp Segment By 8 In Tablespace

1. Check the data file sizes:

SQL>  select file_name,  bytes/1024/1024 from dba_data_files; 
FILE_NAME                                        BYTES/1024/1024
--------------------------------------------- ---------------
/u01/app/oracle/oradata/orcl2/system.dbf                 500
/u01/app/oracle/product/index.dbf                           100
/u01/app/oracle/oradata/orcl2/sysaux.dbf                 100
/u01/app/oracle/oradata/orcl2/undotbs101.dbf            5
/u01/app/oracle/oradata/orcl2/user01.dbf                   10
/u01/app/oracle/oradata/orcl2/user02.dbf                   10

Then resize your datafile or add a new datafile to current tablespace
Resizing Datafile :
ALTER DATABASE DATAFILE ‘/u01/app/oracle/oradata/orcl2/user01.dbf ‘ RESIZE 50M;

SQL> select file_name,  bytes/1024/1024 from dba_data_files;

FILE_NAME                                     BYTES/1024/1024
--------------------------------------------- ---------------
/u01/app/oracle/oradata/orcl2/system.dbf                  500
/u01/app/oracle/product/index.dbf                         100
/u01/app/oracle/oradata/orcl2/sysaux.dbf                  100
/u01/app/oracle/oradata/orcl2/undotbs101.dbf                5
/u01/app/oracle/oradata/orcl2/user01.dbf                   50
/u01/app/oracle/oradata/orcl2/user02.dbf                   50
OR Add Datafile to existing Tablespace:
ALTER TABLESPACE USERS ADD DATAFILE ‘/u01/app/oracle/oradata/orcl2/user01.dbf ‘ SIZE 50M;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: