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.
0