DB As A NE (Doc ID 1515635.1)

Last updated on DECEMBER 04, 2019

Applies to:

Goal

We need to provision a DB considering it as a NE. We would design ASAP cartridges in following way: CSDL1 contains ASDL1 (containing an SQL create), ASDL2 (containing an SQL update) and an ASDL3 containing the commit; Our doubt is: when more than one occurrences of CSDL1 is executed at same time, ASAP is able to guarantee that each commit is executed on a correct set of ASDL belonging to the same CSDL?

An alternative way to design cartridge could be to insert all SQL statements in a single ASDL containing SQL create, update and commit?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.