Home » Server Options » Replication » Oracle Golden Gate extract date format (Oracle Golden Gate 12.1)
Oracle Golden Gate extract date format [message #658075] Fri, 02 December 2016 08:20 Go to next message
dev_sri
Messages: 4
Registered: July 2008
Location: Hyderabad
Junior Member
Team,

we are currently facing initial load issues and need to filter data depending on date criteria :

TABLE SCH_CAT15.EMPLOYEE, SQLPREDICATE 'WHERE TRAN_DATE BETWEEN '31-JAN-15' AND '25-FEB-15'';

Can anyone please provide suggestions on how to provide exact filter conditions.

Rgds,
Sri
Re: Oracle Golden Gate extract date format [message #658098 is a reply to message #658075] Sat, 03 December 2016 13:22 Go to previous messageGo to next message
Littlefoot
Messages: 21446
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I know nothing about Golden Gate. However, '31-jan-15' seems to be a string, so perhaps you'd want to switch to a date instead, such as
date '2015-01-31'
Re: Oracle Golden Gate extract date format [message #658102 is a reply to message #658075] Sat, 03 December 2016 14:06 Go to previous message
BlackSwan
Messages: 26275
Registered: January 2009
Location: SoCal
Senior Member
dev_sri wrote on Fri, 02 December 2016 06:20
Team,

we are currently facing initial load issues and need to filter data depending on date criteria :

TABLE SCH_CAT15.EMPLOYEE, SQLPREDICATE 'WHERE TRAN_DATE BETWEEN '31-JAN-15' AND '25-FEB-15'';

Can anyone please provide suggestions on how to provide exact filter conditions.

Rgds,
Sri
CREATE VIEW would be how I do it.
Previous Topic: Stream Replication b/t 11g and 10 (merged)
Next Topic: Use DBMS_REDEFINITION Package with Goldengate 11g
Goto Forum:
  


Current Time: Sun Nov 18 16:30:55 CST 2018