My Oracle Support Banner

S_DOCK_TXN_LOG ORA-01653: Unable to extend table by 8192 in tablespace (Doc ID 511795.1)

Last updated on APRIL 18, 2023

Applies to:

Siebel Remote - Version 7.5.3.6 SIA [16186] and later
Information 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
 

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.