重庆思庄Oracle、Redhat认证学习论坛

标题: 保证还原点创建及删除 [打印本页]

作者: jiawang 时间: 2020-5-12 09:20
标题: 保证还原点创建及删除
1.创建还原点
create restore point test_scn guarantee flashback database;
create restore point BEFORE_UPGRADE guarantee flashback database;

2.查看还原点
SQL> select name,TIME from v$restore_point;

NAME
--------------------------------------------------------------------------------------------------------------------------------
TIME
---------------------------------------------------------------------------
UPDATE_RSP
12-MAY-20 09.14.38.000000000 AM

3.删除还原点
drop restore point TEST_SCN;
drop restore point BEFORE_UPGRADE;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)