S_DOCK_TXN_LOG 7.x and 8.x ORA-01653: Unable to extend table by 8192 in tablespace
Last updated on AUGUST 01, 2017
Applies to:Siebel Remote - Version 188.8.131.52 SIA  to 184.108.40.206 SIA [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 220.127.116.11  ITA Engy/Oil
Database: Oracle 18.104.22.168
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms