S_DOCK_TXN_LOG 7.x and 8.x ORA-01653: Unable to extend table by 8192 in tablespace
(Doc ID 511795.1)
Last updated on AUGUST 01, 2017
Applies to:Siebel Remote - Version 126.96.36.199 SIA  to 188.8.131.52 SIA [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 184.108.40.206  ITA Engy/Oil
Database: Oracle 220.127.116.11
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.
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?
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