GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

CTAS and insert into select as <tablename>

edited Jan 31, 2014 5:30PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Is there any bug with support for CTAS? 
We executed 
CREATE TABLE cctest AS SELECT * FROM ALL_OBJECTS;
on source and after a few minutes, what we saw was that source and target had different counts. The count never synced and there were no errors on replicat side. This was reproducible.

Also, thinking that the above could be because all_objects was referred which could have different data on both sides, we tried CTAS on a table in the user's schema and it synced correctly. But then we did an INSERT into cctest select * from cctest and this time it did not replicate a single record.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center