My Oracle Support Banner

Veridata Compare Fails Due To Temp Tablespace Issue Or Disk Space Issue (Doc ID 2150544.1)

Last updated on FEBRUARY 26, 2020

Applies to:

Oracle GoldenGate Veridata - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Your Veridata compare using DB sorting:

***********************************************************************
Oracle GoldenGate Veridata
12.2.1.0.0 OGGVDT_12.2.1.0.0_PLATFORMS_151012.2202 For Testing Purposes Only

Copyright (C) 2004, 2015, Oracle and/or its affiliates. All rights reserved

Starting Comparison at 2016-06-16 08:07:18

***********************************************************************

is failing with:

2016-06-16 08:20:09 OGGV-00119: Agent remote message (101): OGGV-60038: Database query failed: 'ORA-01652: unable to extend temp segment by 128 in tablespace TEMP' SQL<select "ACCOUNT_XX", "XXXX_DATE", "XXX_EARNED_POINTS", "XXX_EXPIRED_POINTS", "XXX_ALLOCATED_POINTS", from "XXX"."XXX_DAILY_BALANCE" x order by "XXX_KEY", "XXXX_DATE", "XXX_ID">

Comparison terminated with errors.

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
Cause
Solution
References


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