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
Ïà¹ØÎĵµ£º
Èç¹û½ö½öÊÇlock£¬ÒÔÏÂÓï¾ä¿ÉÒÔ·¢ÏÖËùÓÐÓû§Ëø :
SELECT s.username,
decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL,
o.owner,
o.object_name,
&n ......
SQL> select dbms_metadata.get_ddl('PROCEDURE','PRO2','SCOTT') text from dual;
TEXT
----------------------------------------
CREATE OR REPLACE PROCEDURE "SCOTT"."P
RO2"
is
begin
dbms_output.put_line('wangpeng up');
end;
SQL> select dbms_metadata.get_ddl('PROCEDURE','PRO1','SCOTT') te ......
10ÔÂ10ÈÕµÄÃÀ¹ú¾É½ðɽһÏÂÓ¿ÈëÁË4ÍòÈËÁ÷£¬ËûÃǾۼ¯ÔھɽðɽµÄMoscone»áÕ¹ÖÐÐÄ£¬ÖÜΧ81000¸ö¾Æµê´²Î»±»¶©¹ºÒ»¿Õ£¬¾É½ðɽÊÐÕþ¸®×¨ÃÅ·âËøÁËÖܱßÈýÌõµÀ·µÄ½»Í¨£¬ÒÔΪÕâЩÅÓ´óÈËÁ÷Ìṩ±ãÀû¡£ÕâЩÈ˶¼ÊÇÈ«ÇòITÒµ½çµÄ¾«Ó¢——´ÓIT¾ÞÍ·µÄÁìÐäµ½ÆÕͨµÄÆóÒµIT¼¼ÊõÈËÔ±£¬´Ó×Éѯ»ú¹¹µÄ·ÖÎöÈËÊ¿µ½¸÷ÐÐÒµµÄÐÅÏ¢»¯Ö÷¹Ü£¬µ ......
×ªÔØ
from: http://cid-4e5d038451e31a25.spaces.live.com/blog/cns!4E5D038451E31A25!140.entry
create or replace procedure P_QuerySplit(
sqlscript varchar2, --±íÃû/SQLÓï¾ä
pageSize integer, ......
ÔÚ¿ªÊ¼Ö®Ç°£¬ÐèÒª¼òµ¥ËµÃ÷һϣ¬Ä¿Ç°¹«Ë¾Óм¸¸öÏîÄ¿¶¼²ÉÓÃOracle×÷ΪÊý¾Ý¿âƽ̨£¬²¢ÇÒÓеÄÏîĿʹÓõ½ÁËOracleµÄÊý¾Ý¿â¸´ÖƼ¼Êõ£¬ÆäÖÐÒ²Óöµ½ÁËһЩÎÊÌ⣬Òò´ËÔÚÕâÀÎÒ¶ÔOracleµÄ¸´ÖƼ¼Êõ̸һÏÂÎÒ¸öÈ˵ÄÀí½â£¬Ï£ÍûÄܹ»¶Ô²ÉÓÃOracleÊý¾Ý¿âµÄÏîÄ¿×éÓÐËù°ïÖú¡£ÆäÖÐÔÚÎÄÖÐʹÓõ½µÄSQL½Å±¾¶¼ÊǾ¹ý¼ìÑé¿ÉÒÔÔËÐеġ£
¡¡¡¡Ê ......