Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

Oracle INTERVAL DAY TO SECONDÊý¾ÝÀàÐÍ

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) ] } ......

Oracle£ºÒ»¸öIT¡°Èںϡ±¾ÞÍ·µÄµ®Éú

 10ÔÂ10ÈÕµÄÃÀ¹ú¾É½ðɽһÏÂÓ¿ÈëÁË4ÍòÈËÁ÷£¬ËûÃǾۼ¯ÔھɽðɽµÄMoscone»áÕ¹ÖÐÐÄ£¬ÖÜΧ81000¸ö¾Æµê´²Î»±»¶©¹ºÒ»¿Õ£¬¾É½ðɽÊÐÕþ¸®×¨ÃÅ·âËøÁËÖܱßÈýÌõµÀ·µÄ½»Í¨£¬ÒÔΪÕâЩÅÓ´óÈËÁ÷Ìṩ±ãÀû¡£ÕâЩÈ˶¼ÊÇÈ«ÇòITÒµ½çµÄ¾«Ó¢——´ÓIT¾ÞÍ·µÄÁìÐäµ½ÆÕͨµÄÆóÒµIT¼¼ÊõÈËÔ±£¬´Ó×Éѯ»ú¹¹µÄ·ÖÎöÈËÊ¿µ½¸÷ÐÐÒµµÄÐÅÏ¢»¯Ö÷¹Ü£¬µ ......

ORACLE ʹÓÃDBMS_METADATA.GET_DDL»ñÈ¡DDLÓï¾ä

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·¢ËÍÓʼþ´æ´¢¹ý³Ì:

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ