Can Restore Point be Created at Schema Level

刘泽宇

目标：
Is it Possible to Create Restore point/Guaranteed restore point at schema level.



处理方法：
Restore points can be created only at the database level (CDB or PDB). Currently, there is no option to create a restore point at the schema level.

To flashback the tables of a particular schema, you can explore using the below options:

To flashback a table to a particular time, you can explore using FLASHBACK_SCN or FLASHBACK_TIMESTAMP in expdp or the Flashback query option to create a copy of the table based on the timestamp. Both of these depend on Undo retention.
Flashback Data Archive (FDA) was introduced in Oracle 11g to allow you to protect UNDO information, allowing guaranteed flashback queries. Based on this, you can create new table data for a particular time.