高级搜索 返回首页  
名人名言
技术文章
山阴客技术文章保证还原点创建及删除
保证还原点创建及删除
2020-08-27 15:33:25
by 保证还原点创建及删除  
Rating: not rated yet
1 2 3 4 5 6 7 8 9 10

保证还原点创建及删除

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;

推荐给好 src="images/mail.gif" align=absMiddle border=0> 打包下载这篇文章 打印这篇文章

  showcomment   there are 8 comment
subject:
name:E-mail


Copyright © 2019 http://www.shanyinke.com
All rights reserved.

Powered by: 少达文章管理系统 Version 1.0dev
备案号:浙ICP备17002154号-3
Processed Time: 0.0031 s Querys: 5 [ Gzip Level 0 ]