2018年6月8日
摘要: Oracle Flashback Transaction Query with Oracle Flashback Version Query In this example, a database administrator does this: Now emp and dept have one 阅读全文
posted @ 2018-06-08 15:47 HelonTian 阅读(150) 评论(0) 推荐(0) 编辑
摘要: Oracle Flashback Database To use the FLASHBACK DATABASE command to return your database contents to points in time within the flashback window, your d 阅读全文
posted @ 2018-06-08 15:46 HelonTian 阅读(117) 评论(0) 推荐(0) 编辑
摘要: The following list summarizes the user privileges required for the operations related to Flashback Drop and the recycle bin: DROP Any user with DROP p 阅读全文
posted @ 2018-06-08 15:35 HelonTian 阅读(196) 评论(0) 推荐(0) 编辑
摘要: Ensure that the prerequisites described in Prerequisites for Flashback Table are met. To use the Flashback Table feature on one or more tables, use th 阅读全文
posted @ 2018-06-08 15:27 HelonTian 阅读(186) 评论(0) 推荐(0) 编辑
摘要: 新上线MySQL数据库规划1.删除test库2.删除root用户或者让root用户只可在本机登陆而对于有业务访问的数据库,在做删除root用户前需要依次确认 function、procedure、event、view、trigger的definer;有definer为root@%或root@xxx需 阅读全文
posted @ 2018-06-08 11:03 HelonTian 阅读(142) 评论(0) 推荐(0) 编辑