还剩3页未读,继续阅读
文本内容:
oracle数据恢复电脑资料oracle数据恢复dropdel
1、delete后恢复最好是立即进行恢复insertintomytestselect*frommytestasoftimestampto_timestampxx-07-1115:18:04yyyy-mm-ddhh24:mi:ss2droptable恢复a先确保showparameterrecyclebin状态是onbselect*fromrecyclebin/showrecyclebinselect*fromrecyclebinwhereoriginal_name=MYTEST;c、如果有对应的表,则进行恢复flashbacktablemytesttobeforedropok,搞定其他sql语句总结清空回收站purgerecyclebin;清空所有用户的回收站purgedba_recyclebin;批量生成数据createtablemytestasselectrownumasidto_charsysdateyyyy-mm-ddhh24:mi:ssasinc_timetruncdbms_random.value01000asrandom_iddbms_random.stringx20asrandom_stringfromdualconnectbylevel=1000;查询可用空间SELECTtextview_nameFROMdba_viewsWHEREview_name=DBA_FREE_SPACE;selecttextview_namefromdba_views查询当前的sselectdbms_flashback.get_system_change_numberfromdual;--548966查询符合条件的s,并且保持到临时表createtables_tempcountintsint;declareiint:=548000;beginforiin
548000..548966loopinserti...。