保证还原点创建及删除
2020-08-27 15:33:25
by 保证还原点创建及删除

打印???
天盟网(http://www.aksky.com)
技术文章(http://www.aksky.comhref=category.php?cid=1)

保证还原点创建及删除

1.创建还原点

create restore point test_scn guarantee flashback database;

create restore point BEFORE_UPGRADE guarantee flashback database;

2.查看还原点

1* select name,TIME from v$restore_point

NAME TIME

-------------------- ----------------------------------------

TEST_SCN 10-DEC-12 12.21.08.000000000 AM

BEFORE_UPGRADE 10-DEC-12 12.37.01.000000000 AM

3.删除还原点

drop restore point TEST_SCN;

drop restore point BEFORE_UPGRADE;



Copyright © 2002-2022 http://www.aksky.com
All rights reserved.

备案号:浙ICP备17002154号-2 Powered by: myarticle.com.cn Version 1.0dev
Processed Time: 0.0015 s Querys: 4 [ Gzip Level 0 ]