OraFAQ Forum: Replication » Oracle Golden Gate extract date format

Home » Server Options » Replication » Oracle Golden Gate extract date format (Oracle Golden Gate 12.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Golden Gate extract date format [message #658075]

Fri, 02 December 2016 08:20

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

Report message to a moderator

Re: Oracle Golden Gate extract date format [message #658098 is a reply to message #658075]

Sat, 03 December 2016 13:22

Littlefoot
Messages: 21782
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'

Report message to a moderator

Re: Oracle Golden Gate extract date format [message #658102 is a reply to message #658075]

Sat, 03 December 2016 14:06

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	Stream Replication b/t 11g and 10 (merged)
Next Topic:	Use DBMS_REDEFINITION Package with Goldengate 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 27 10:52:48 CDT 2023