Looking at the top-level error, it looks like one of two things has
happened. Your table has reached its maximum size within your schema
(limited by the number of max extents for that table - a unit of Oracle
storage, 2k default I think), or your schema itself has reached its maximum
size for its tablespace.
If you can add data to other tables in the same schema it probably means
that your table has grown outwith its own limits, if you can't it probably
means you've ran out of space for your whole schema.
Either way, get your DBA to look at it but you'll probably have to add
another datafile to the tablespace for your schema.
Paul.
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of sandarbh
Sent: Tuesday, April 24, 2001 10:02 AM
To: [EMAIL PROTECTED]
Subject: urgent
Hi all,
Can anyone give me a clue to this error which raised when 13469 records were
inserted through a program in java.
********************************************
java.sql.SQLException: ORA-01631: max # extents (121) reached in table
CAS_USER.
MODULE_LOG
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:181)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:631)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1225)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:661
)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:780)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement
.java:822)
at
oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:116
4)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1210)
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java
:1227)
at ConnectionManager.insertRecords(ConnectionManager.java:25)
at DbHandlerFeeder.updatedata(DbHandlerFeeder.java:239)
at DbHandlerFeeder.sendToDatabase(DbHandlerFeeder.java:391)
at
LogHandlerCaller.feederdetaillogmanipulation(LogHandlerCaller.java:11
7)
at LogHandlerMain.pathForFeeder(LogHandlerMain.java:122)
at LogHandlerMain.main(LogHandlerMain.java:164)
The time is :2317
**********************************
Regards,
Sandarbh
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
__________________________________________________________________________
Graham Technology plc,
Registered in Scotland No: 143434
Registered Office, Torr Hall, Torr Road, Bridge of Weir, PA11 3RU, UK
Telephone: +44 (0) 1418914000
Fax: +44 (0) 1418822114
Website: http://www.gtnet.com/
__________________________________________________________________________
This email (and any attachment) is private and confidential. If you were
not meant to receive it, please delete it and tell us by phone or email.
Although we scan all email and attachments we do not accept responsibility
for viruses.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
