Forum Stats

  • 3,826,733 Users
  • 2,260,699 Discussions


ORA-01653: unable to extend table

445084 Member Posts: 268
edited Jul 14, 2006 7:18AM in General Database Discussions
Hi all,

I am using oracle 10g AS.Our application is in production. I am facing this error.plz help me bcoze i have to solve this issue.


  • Paul M.
    Paul M. Member Posts: 10,947 Gold Trophy
    That error normally means you don't have space enough in the tablespace. You should post the complete error stack you get.
  • 445084
    445084 Member Posts: 268
    The complete error log stack is as following:

    oracle.panama.messaging.transport.impl.InternalTransportException: transport internal exception: java.sql.SQLException: ORA-01653: unable to extend table WIRELESS.TRANS_STORE by 8192 in tablespace IAS_META
    ORA-06512: at "WIRELESS.TRANSPORT", line 313
    ORA-06512: at "WIRELESS.TRANSPORT", line 681
    ORA-06512: at line 1

    at oracle.jdbc.driver.DatabaseError.throwSqlException(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4CTTIoer.processError(
    at oracle.jdbc.driver.T4C8Oall.receive(
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(
    at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
    at oracle.jdbc.driver.OraclePreparedStatement.execute(
    at oracle.jdbc.driver.OracleCallableStatement.execute(
    at oracle.panama.messaging.transport.impl.DBStorage.enqueueSendingMessage(
    at oracle.panama.messaging.transport.impl.SendingBilling.send(
    at oracle.panama.messaging.transport.impl.MessengerImpl.deliver(

  • 376714
    376714 Member Posts: 2,061
    Then it appears that tablespace IAS_META is full. You should whether add a new datafile to the tablespace, or increase existing datafile(s) size.

  • 445084
    445084 Member Posts: 268
    Please let me know the exact queury to ADD new data file and to INCREASE fize of existing tablespace.

  • 376714
    376714 Member Posts: 2,061
    ALTER TABLESPACE tablespace_name ADD DATAFILE 'path_and_file_name' SIZE xxxM AUTOEXTEND OFF;
    ALTER DATABASE DATAFILE 'path_and_file_name' RESIZE xxxM;
    Of course xxx is the size in MiB, tablespace_name is IAS_META and path_and_file_name is the absolute path and file name of the datafile to be added or resized.

  • 511208
    511208 Member Posts: 472
    ALTER TABLESPACE tablespace_name ADD DATAFILE path SIZE file_size ;

  • 445084
    445084 Member Posts: 268

    But 1 thing is to tell u...there is only 4.35 GB space on drive where oracle is installed.
    I m going to increase the tablespce.
    anyway i think we must increase harddarive?
    What do u think?

  • orafad
    orafad Member Posts: 8,035 Silver Trophy
    Data files makes up the physical storage capacity of a tablespace. So add datafile is the same as increasing size of tablespace.

    If you got more syntax questions and the like, I recommend to use the manuals. In this specific case, the Sql Reference guide.
    Go search
  • 376714
    376714 Member Posts: 2,061
    anyway i think we must increase harddarive?
    only you can anser this... it depends on many things:
    . What's the dayly/monthly data grow?
    . How much free space/occupied space is there in the filesystems/tablespaces/datafiles?
    . What's the overall database size ?
    . Can you expect "burst growth" or is it constant growth?

  • 445084
    445084 Member Posts: 268
    Total harddisk space = 72GB
    O/S drive is on 15 GB and 54GB is for oracle drive.
    tablespace taking space=32GB
    other tablespaces = 5GB
    Free space on this drive = 4 GB.

This discussion has been closed.