Hi, >Thanks Gopal. Indeed table t is defined as ORC and transactional. > >Any reason why this should not work for transactional tables?
The committed transactions list is actually missing from the exported metadata. So the EXPORT as it exists today is a dirty read snapshot, which is not a good thing when the data is continously being streamed in. I don't think IMPORT likes that (and why should it?). Try with a fully compacted table. Cheers, Gopal