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

Last updated on JULY 17, 2017

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_KEY", "BALANCE_DATE", "END_EARNED_POINTS", "END_EXPIRED_POINTS", "END_ALLOCATED_POINTS", "END_REDEEMED_POINTS", "SOURCE_ID", "AUD_CREATED_BY", "AUD_CREATED_DTTM", "AUD_UPDATED_BY", "AUD_UPDATED_DTTM" from "LSP"."MBR_EXT_ACCT_DAILY_BALANCE" x order by "ACCOUNT_KEY", "BALANCE_DATE", "SOURCE_ID">

Comparison terminated with errors.

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