返回数说广场 #日有所学#
0
你在 Oracle 11g 版本 1 数据库上执行了 DROP USER 级联,并立即意识到您忘记了复制 OCA。EXAM_RESULTS表 to o ocp 架构。在执行 DROP USER 之前启用RECYCLE_BIN,并且 OCP 用户已被授予"闪回任何表系统"权限。恢复 OCA 内容的最快方法是什么?EXAM_RESULTS表到 OCP 架构?
执行闪回计划 OCA。EXAM_RESULTS删除重命名之前TO EXAM_RESULTS;作为 OCP 用户连接。
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema????
Recover the table using Automated Tablespace Point In Time Recovery.
----
When you perform a drop user or drop user cascade, the recycle bin is purge by default.
0
0 97
分享
评论
热门数说


