Forum Stats

  • 3,826,733 Users
  • 2,260,699 Discussions
  • 7,897,065 Comments

Discussions

ORA-01653: unable to extend table

445084
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.
vpulivarthi
«1345

Comments

  • 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(DatabaseError.java:137)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:180)
    at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:790)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1109)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2901)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2992)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4124)
    at oracle.panama.messaging.transport.impl.DBStorage.enqueueSendingMessage(DBStorage.java:620)
    at oracle.panama.messaging.transport.impl.SendingBilling.send(SendingBilling.java:125)
    at oracle.panama.messaging.transport.impl.MessengerImpl.deliver(MessengerImpl.java:1216)


    REgs,
    Saqib
  • 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.

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

    Thanks
  • 376714
    376714 Member Posts: 2,061
    ADD:
    ALTER TABLESPACE tablespace_name ADD DATAFILE 'path_and_file_name' SIZE xxxM AUTOEXTEND OFF;
    INCREASE:
    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.

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

    Thanks
  • 445084
    445084 Member Posts: 268
    Thanks!

    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?

    Saqib
  • 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 http://tahiti.oracle.com
  • 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?

    Yoann.
  • 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.


    Saqib
This discussion has been closed.