S_DOCK_TXN_LOG ORA-01653: Unable to extend table by 8192 in tablespace
(Doc ID 511795.1)
Last updated on SEPTEMBER 11, 2024
Applies to:
Siebel Remote - Version 7.5.3.6 SIA [16186] and laterInformation in this document applies to any platform.
Product Release: V7 (Enterprise)
Version: 7.5.3.6 [16186] ITA Engy/Oil
Database: Oracle 9.2.0.4
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: Redhat Linux Advanced Server 2.1
This document was previously published as Siebel SR 38-2497648834.
Symptoms
When we try to modify a record in Test environment, we get the following error:
Si è verificato un errore durante la scrittura di un record” [...]
ORA-01653: Unable to extend table SIEBL. s_dock_txn_log by 8192 in tablespace
We think it is due to a full s_dock_txn_log table (it contains over 8.000.000 records).
Most of the records are on Item_Names:
- S_SRM_REQUEST (Limited, 4.000.000 records)
- S_WF_STEP_INST (Private, 3.000.000 records)
We do not use Siebel Remote, and we know that creating remote users we should manage to resolve the issue.
We cannot make tests in Test environment due to the error I mentioned (we cannot create any kind of record).
In development environment we have taken the following actions:
- created a remote client pointing on a user with many positions
- created another remote user pointing on SADMIN.
- Run generate new db
- Extracted the 2 clients
Transaction Processor and router are running, but the table record nr. continues to increase.
We have the following questions:
1- How can we resolve error ORA-01653?
2- In general, How can we empty table s_dock_txn_log?
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |