All,

We are getting below error while creating a table. In the current session no other bulk load has happened.

CREATE TABLE IF NOT EXISTS "SCHEMA_NAME"."TABLE_NAME"

        AS

        SELECT * FROM " SCHEMA_NAME "."TABLE_NAME" WHERE 1=0;

        INSERT

        INTO "SCHEMA_NAME"."TABLE_NAME"

        SELECT * FROM "SCHEMA_NAME"."TABLE_NAME2";

ERROR = !COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead

~

Also, is there a way to update multiple tables at the same time without above error? Is this due to concurrent insert?

Any help here is much appreciated!

Regards,

Sreejith