Veridata Compare Fails Due To Temp Tablespace Issue Or Disk Space Issue
(Doc ID 2150544.1)
Last updated on MAY 11, 2022
Applies to:
Oracle GoldenGate Veridata - Version 12.2.1.0.0 and laterInformation 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 |