OraFAQ Forum: Replication » still error OGG-01896 is raised after dropping identity feature

Home » Server Options » Replication » still error OGG-01896 is raised after dropping identity feature

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

still error OGG-01896 is raised after dropping identity feature [message #674006]

Mon, 24 December 2018 01:02

fabi88
Messages: 112
Registered: November 2011

Senior Member

Hi experts,

I had a table with identity column,I have modified table to drop identity so identity column no longer exists. But I still get error OGG-01896 :Table has an identity column which is not supported.

How can resolve this issue without dropping whole table?

Report message to a moderator

Re: still error OGG-01896 is raised after dropping identity feature [message #674008 is a reply to message #674006]

Mon, 24 December 2018 08:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What is OS name & version?
Post results from SQL below

SELECT* FROM V$VERSION;

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: still error OGG-01896 is raised after dropping identity feature [message #674010 is a reply to message #674008]

Tue, 25 December 2018 05:08

fabi88
Messages: 112
Registered: November 2011

Senior Member

Thank you for your attention,I have no access to the database now for posting results from SQL,so I answer your questions:

OS NAME & Version : Oracle Linux 6.7
Database version : 12.1.0.2

Report message to a moderator

Re: still error OGG-01896 is raised after dropping identity feature [message #674011 is a reply to message #674010]

Wed, 26 December 2018 01:47

John Watson
Messages: 8795
Registered: January 2010
Location: Global Village

Senior Member

Your release of GoldenGate is more important, are you using 18?

Report message to a moderator

Re: still error OGG-01896 is raised after dropping identity feature [message #674014 is a reply to message #674011]

Wed, 26 December 2018 04:40

fabi88
Messages: 112
Registered: November 2011

Senior Member

Hi,

Golden Gate version is : 12.3.0.1.4

Report message to a moderator

Re: still error OGG-01896 is raised after dropping identity feature [message #674015 is a reply to message #674014]

Wed, 26 December 2018 05:07

John Watson
Messages: 8795
Registered: January 2010
Location: Global Village

Senior Member

Well, go on - what do you think you should do to fix the problem?

Report message to a moderator

Re: still error OGG-01896 is raised after dropping identity feature [message #674022 is a reply to message #674006]

Thu, 27 December 2018 01:25

fabi88
Messages: 112
Registered: November 2011

Senior Member

I don't know what should I do Sad

Report message to a moderator

Re: still error OGG-01896 is raised after dropping identity feature [message #674027 is a reply to message #674022]

Thu, 27 December 2018 05:35

John Watson
Messages: 8795
Registered: January 2010
Location: Global Village

Senior Member

fabi88 wrote on Thu, 27 December 2018 07:25

I don't know what should I do

This looks suspiciously like trolling: pretending to be stupid, in order to make people angry. However, I shall be generous and assume that it is not a pretense.

You need to upgrade your GoldenGate to the current release. Release 12.3.0.1 cannot handle identity columns.

Report message to a moderator

Re: still error OGG-01896 is raised after dropping identity feature [message #674030 is a reply to message #674027]

Thu, 27 December 2018 09:39

fabi88
Messages: 112
Registered: November 2011

Senior Member

Nice, very nice. Did you read my question? Do you think that I said I am going to use identity column!!!!!???

Quote:

This looks suspiciously like trolling: pretending to be stupid, in order to make people angry.

You took the words out of my mouth.

Report message to a moderator

Re: still error OGG-01896 is raised after dropping identity feature [message #674346 is a reply to message #674006]

Tue, 22 January 2019 05:53

abed24
Messages: 18
Registered: October 2006
Location: Jordan

Junior Member

you need to skip the transactions that happened while identity column existed:

alter replicat rep1 begin now
start replicat rep1

Report message to a moderator

Previous Topic:	Understanding MV refresh concept
Next Topic:	OGG-01232

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 06 07:01:57 CST 2023