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
Ïà¹ØÎĵµ£º
Ïȶ¨ÒåÒ»¸öcursor:
Procedure P_MYPROC (
PI_PARAM VARCHAR2
)IS
VI_A&nb ......
Step1. Insert empty_clob() into the Clob column of Oracle
Step2. Set autocommit to false
Step3. Select Clob as oracle.sql.CLOB from database
Step4. Insert String into Clob
Step5. Commit
Example:
import java.sql.*;
import java.io.*;
import oracle.jdbc.driver.OracleResultSet;
......
ÔÚORACLEÖо³£»áÅöµ½×èÈûµÄÇé¿ö·¢Éú£¬Õâ¸öʱºòÎÒÃǾÍÐèÒª¿ìËÙµÄÕÒ³öµ¼ÖÂ×èÈûµÄÔÒò£¬²¢¾¡¿ìÅųýËü£¬ºÃÈÃÏµÍ³ÖØÐÂÕý³£ÔËÐС£
ÏÂÃæÒÔËÀËøÎªÀý£¬À´¿´¿´ÈçºÎÕÒ³öµ¼ÖÂ×èÈûµÄ»á»°²¢½â¾öÎÊÌâ¡£
//SCOTT´°¿Ú1
SQL> select * from t2;
ID
----------
3
1
2
SQL> update t2 set i ......
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µÄÊý¾Ý¿â¸´ÖƼ¼Êõ£¬ÆäÖÐÒ²Óöµ½ÁËһЩÎÊÌ⣬Òò´ËÔÚÕâÀÎÒ¶ÔOracleµÄ¸´ÖƼ¼Êõ̸һÏÂÎÒ¸öÈ˵ÄÀí½â£¬Ï£ÍûÄܹ»¶Ô²ÉÓÃOracleÊý¾Ý¿âµÄÏîÄ¿×éÓÐËù°ïÖú¡£ÆäÖÐÔÚÎÄÖÐʹÓõ½µÄSQL½Å±¾¶¼ÊǾ¹ý¼ìÑé¿ÉÒÔÔËÐеġ£
¡¡¡¡Ê ......