ORA-01652: unable to extend temp segment by %s in tablespace %s

    You are trying to create a temporary segment but there is not enough space left in the tablespace.


    When you try to create a new table or index in a tablespace, it is first created as a temporary segment inside the tablespace before the actual segment is created. There was not enough space left inside the tablespace to successfully complete the creation


    eg:

    SQL> create tablespace very_small datafile 'C:\ORACLE\ORADATA\VS01.DBF' size 128k;

    Tablespace created.

    SQL> create table very_large tablespace very_small as select * from dba_objects;
    create table very_large tablespace very_small as select * from dba_objects
                                                                   *
    ERROR at line 1:
    ORA-01652: unable to extend temp segment by 8 in tablespace VERY_SMALL


    In order to solve the problem either extend the datafile attached to the tablespace, add a new datafile to the tablespace or turn on the autoextend feature of the datafile(s).



    To check what datafile are attached to the tablespace, use following command:



    select file_name, bytes, maxbytes, autoextensible
    from dba_data_files
    where tablespace_name='VERY_SMALL'

    To add more space to a file issue following command:

    alter database datafile 'C:\ORACLE\ORADATA\VS01.DBF' resize 1m;

    To turn on the autoextend feature on a datafile use following command:

    alter database datafile 'C:\ORACLE\ORADATA\VS01.DBF' autoextend on next 100m maxsize 2000m;


Adverteren bij Daisycon
Forum Messages
No messages
Add your message for ORA-01652
Name:email:
Validation Code:ud6we4qvei5ey72pk
Enter Code above:
Title:
State your problem: