VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

一些数据对象的查找脚本

Posted by admin on 28th July 2012

在帮银联恢复数据库的时候 客户要求导出库里的一些存储过程,这里整理了一些脚本供大家使用

创建view

select 
  'CREATE OR REPLACE VIEW '||O.NAME||' ('||
   replace(c.c[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

模拟一次online redo crash 的恢复

Posted by admin on 7th December 2011

[oracle@liu dbs]$ sqlplus ‘/as sysdba’

SQL*Plus: Release 10.2.0.1.0 – Production on Wed Dec 7 00:06:50 2011

Copyright (c) 1982, 2005, Oracle. Al[......]

Read more

Tags:
Posted in NBU | No Comments »