ORA-01653: unable to extend table

445084

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.

That error normally means you don't have space enough in the tablespace. You should post the complete error stack you get.

445084

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

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

Please let me know the exact queury to ADD new data file and to INCREASE fize of existing tablespace.

Thanks

376714

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

ALTER TABLESPACE tablespace_name ADD DATAFILE path SIZE file_size ;

Thanks

445084

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

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

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

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