Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does TOYS permit on-line use of the database while the synchronization is executing?

April 26, 2017database executing line on-line permit synchronization TOYS

0

10 Posted

Does TOYS permit on-line use of the database while the synchronization is executing?

1 Answer

0

Posted

Currently, TOYS does not facilitate use of that part of the database being updated while the synchronization process executes. Futhermore, TOYS assumes that it has exclusive use of those parts of the database it is updating. If this is not the case then the process is likely to fail. It is up to you to ensure that end-users are denied access while the synchronization process executes. Future releases of TOYS will use the on-line redefinition facility [introduced in Oracle 9i] to enable on-line synchronization [for simple cases]. It is expected that while this allows the database to be used during the synchronization processing it will require significantly greater resources.