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 and later
Information in this document applies to any platform.


Your Veridata compare using DB sorting:

Oracle GoldenGate Veridata OGGVDT_12. 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.


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

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