C#±¸·ÝOracle´úÂë
ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
/// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <returns>true:±¸·Ý³É¹¦;false:±¸·Ýʧ°Ü</returns>
public static bool DBBackup(string dmpFileName, string logFileName)
{
// ·µ»ØÖµ
bool result = false;
// ±¸·ÝÃüÁî,´ÓxmlÎļþÖлñÈ¡ "/c EXP Óû§Ãû/ÃÜÂë@Êý¾Ý¿â·þÎñÃû FULL=Y INCTYPE=COMPLETE "
string backupCmd = MsgXml.GetConfig(XMLKey.BackupCommand.ToString());
// cmdÖÐÊäÈëµÄ²ÎÊýÄÚÈÝ
string arg = backupCmd + " FILE= " + dmpFileName + " LOG= " + logFileName;
try
{
// Èç¹ûdmpÎļþ²»´æÔÚ£¬´´½¨Îļþ²¢ÊÍ·Å
if (!File.Exists(dmpFileName))
{
File.Create(dmpFileName).Dispose();
}
// Èç¹ûlogÎļþ²»´æÔÚ£¬´´½¨Îļþ²¢ÊÍ·Å
if (!File.Exists(logFileName))
{
File.Create(logFileName).Dispose();
}
// ¿ªÆôнø³Ì
Process process = new Process();
// ´ò¿ªÔËÐÐcmd
process.StartInfo.FileName = "cmd.exe";
// ÒªÔËÐеÄÃüÁî
process.StartInfo.Arguments = arg;
// ¹Ø±ÕshellµÄʹÓÃ
process.StartInfo.UseShellExecute = false;
// ÖØ¶¨Ïò±ê×¼ÊäÈë
process.StartInfo.RedirectStandardInput = true;
process.StartInfo.RedirectStandardError = true;
// ÉèÖò»ÏÔʾcmdÔËÐнçÃæ
process.StartInfo.CreateNoWindow = true;
// Æô¶¯½ø³Ì
process.Start();
// TODO ½ø³ÌÌõ ÕýÔÚ±¸·Ý£¬ÇëÉÔºò...
pr
Ïà¹ØÎĵµ£º
INTERVAL DAY TO SECONDÊý¾ÝÀàÐÍ
OracleÓï·¨:
INTERVAL '{ integer | integer time_expr | time_expr }'
{ { DAY | HOUR | MINUTE } [ ( leading_precision ) ]
| SECOND [ ( leading_precision [, fractional_seconds_precision ] ) ] }
[ TO { DAY | HOUR | MINUTE | SECOND [ (fractional_seconds_precision) ] } ......
10ÔÂ10ÈÕµÄÃÀ¹ú¾É½ðɽһÏÂÓ¿ÈëÁË4ÍòÈËÁ÷£¬ËûÃǾۼ¯ÔھɽðɽµÄMoscone»áÕ¹ÖÐÐÄ£¬ÖÜΧ81000¸ö¾Æµê´²Î»±»¶©¹ºÒ»¿Õ£¬¾É½ðɽÊÐÕþ¸®×¨ÃÅ·âËøÁËÖܱßÈýÌõµÀ·µÄ½»Í¨£¬ÒÔΪÕâЩÅÓ´óÈËÁ÷Ìṩ±ãÀû¡£ÕâЩÈ˶¼ÊÇÈ«ÇòITÒµ½çµÄ¾«Ó¢——´ÓIT¾ÞÍ·µÄÁìÐäµ½ÆÕͨµÄÆóÒµIT¼¼ÊõÈËÔ±£¬´Ó×Éѯ»ú¹¹µÄ·ÖÎöÈËÊ¿µ½¸÷ÐÐÒµµÄÐÅÏ¢»¯Ö÷¹Ü£¬µ ......
Oracle ÔÚ9iÒԺ󣬿ÉÒÔÀûÓÃDBMS_METADATA.GET_DDL°üµÃµ½Êý¾Ý¿âµÄ¶ÔÏóµÄddl½Å±¾¡£ÈçÏ£¨SQLPLUSÖÐÖ´ÐУ©£º
1. »ñÈ¡µ¥¸öµÄ½¨±í¡¢ÊÓͼºÍ½¨Ë÷ÒýµÄÓï·¨
set pagesize 0
set long 90000
set feedback off
set echo off
spool DEPT.sql
select dbms_metadata. ......
oracle·¢ËÍÓʼþ´æ´¢¹ý³Ì:
create or replace procedure bsd_sendemail(
p_receiver varchar2,
p_sub varchar2,
p_txt varchar2)
is
p_user varchar2(30):='';
p_pass varchar2(30):='';
p_sendor varchar2(20):='Gnie';
p_server varchar2(20):='Mail_Server_IP';
p_port number:=25;
p_need_smtp number:=0;
p ......