Çó oracle ±¸·ÝÊý¾Ý¿âµÄ´æ´¢¹ý³Ì

ÇóÒ»oracleÖб¸·ÝÊý¾Ý¿âµÄ´æ´¢¹ý³Ì£¬Ï£Íû¸÷λ¸ßÊÖÄܸøÎÒ¸ö²âÊÔͨ¹ýµÄ£¬²»Ê¤¸Ð¼¤£¡£¡£¡

---

/*±¸·ÝÊý¾Ý¿âµÄ´æ´¢¹ý³Ì*/
if exists(
select * from sysobjects
  where name='pr_backup_db' and xtype='p'
          )
begin
drop proc pr_backup_db
end
go

create proc pr_backup_db
@flag varchar(20) out,
@backup_db_name varchar(128),
@filename varchar(1000)  --·¾¶£«ÎļþÃû×Ö
as
declare @sql nvarchar(4000),@par nvarchar(1000)
if not exists(
select * from master..sysdatabases
  where name=@backup_db_name
  )
begin
select @flag='db not exist'  /*Êý¾Ý¿â²»´æÔÚ*/
return
end
else
begin
if right(@filename,1) <>'\' and charindex('\',@filename) <>0
begin
  select @par='@filename varchar(1000)'
  select @sql='BACKUP DATABASE '+@backup_db_name+' to disk=@filename with init'
  execute sp_executesql @sql,@par,@filename
  select @flag='ok'
  return
end
else
begin
  select @flag='file type error'  /*²ÎÊý@filenameÊäÈë¸ñʽ´íÎó*/
  return
end
end

GO


±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/haojialin/arch