You'll need to post more details.
The ora-0001 message is only possible on INSERT, NOT SELECT!
You probably also need to explain which application you are using, and
why your application lasts over a week.
The most efficient solution is probably to implement connection pooling
using either facilities available in your product, or in Oracle.
Note: Connections will not reconnect, unless you have an appropiate
exception handler in your program, use the exception handler to
reconnect and to return to the offending location.
--
Sybrand Bakker
Senior Oracle DBA
Received on Fri Jun 17 2005 - 05:10:02 CDT
