select "ID", max("Relevant") as "Relevant", "LongDescription", max("A") as "A", max("B") as "B", max("C") as "C", listagg("Comment", ' // ') within group (order by null) as "Comment" from dummyTable group by "ID", "LongDescription" order by "ID"; http://www.sqlfiddle.com/#!4/af6db4/15


A child table may be exported at some point of time, let's say 12:00. Then as expdp goes on, the parent table may be exported minutes later, let's say at 12:05. Your dump file contains the content of those tables from different points of times. Yes, if those tables were changing during that 5 minutes, their relation may become inconsistent and you will get ...

Only top voted, non community-wiki answers of a minimum length are eligible