Facilitating operations on pluggable databases using separate logical timestamp services

A computer-executed method comprising:

• executing a first query over a read-only pluggable database in a standby container database that replicates data from a primary container database;
• wherein the first query requires a write operation;
• wherein executing the first query further comprises:
• automatically generating a second operation that performs the write operation in a private pluggable database in the standby container database,
• determining a logical timestamp (LT) for the second operation based on a first LT service maintained for the private pluggable database,
• wherein the first LT service maintained for the private pluggable database is distinct from a second LT service maintained for the standby container database, and
• executing the second operation based, at least in part, on the LT determined for the second operation;
• wherein the method is performed by one or more computing devices.

One or more computer-readable media storing one or more sequences of instructions which, when executed by one or more processors, cause:

• performing a refresh operation on a cloned pluggable database based, at least in part, on redo entries recorded for a source pluggable database;
• while performing the refresh operation on the cloned pluggable database, receiving a query over the cloned pluggable database;
• determining a logical timestamp (LT) for the query based on a first LT service that is maintained for the cloned pluggable database;
• wherein the first LT service maintained for the cloned pluggable database is distinct from a second LT service that is maintained for a container database that contains the cloned pluggable database;
• executing the query over the cloned pluggable database based, at least in part, on the LT for the query.

One or more computer-readable media storing one or more sequences of instructions which, when executed by one or more processors, cause:

• executing a first query over a read-only pluggable database in a standby container database that replicates data from a primary container database;
• wherein the first query requires a write operation;
• wherein executing the first query further comprises:
• automatically generating a second operation that performs the write operation in a private pluggable database in the standby container database,
• determining a logical timestamp (LT) for the second operation based on a first LT service maintained for the private pluggable database,
• wherein the first LT service maintained for the private pluggable database is distinct from a second LT service maintained for the standby container database, and
• executing the second operation based, at least in part, on the LT determined for the second operation.