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 7.5.3.6 SIA [16186] to 8.2.2.1 SIA[23012] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
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

Hi.
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?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms