oracle 8iÔöÁ¿±¸·Ý³öÏÖµÄÎÊÌâ
ÒÔÏÂÊÇÍêÕûµÄÖ´Ðйý³Ì£¬ÓÐÈý¸ö±í¿Õ¼ä¿ÉÒÔÔöÁ¿±¸·Ý³É¹¦µÄ£¬µ½Õû¸öÊý¾Ý¿âʱ¾ÍÓÐÎÊÌâÁË£¬Çë´óϺ½â»ó
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production With the Partitioning option JServer Release 8.1.7.4.1 - Production
Oracle Êý¾Ý¿â¹éµµÄ£Ê½£ºARCHIVELOG
SUNSERVER ·ÖÎö½áÊø£¬×ÜÎļþ¸öÊý£º 1£¬×ÜÊý¾ÝÁ¿´óС£º δ֪´óС£¬¿ªÊ¼±¸·Ý²Ù×÷
Recovery Manager: Release 8.1.7.4.1 - Production
RMAN> connect target internal/oracle@orcl;
2>
3> run {
4> allocate channel d1 type 'SBT_TAPE';
5> backup incremental level 1 format 'ORDB_%d_%s_%p_%t' database tag '2009_7_2_16_58_51';
6> release channel d1;
7> }
8>
9> run {
10> allocate channel d1 type 'SBT_TAPE';
11> backup current controlfile format 'CTRL_%d_%s_%p_%t' tag '2009_7_2_16_58_51';
12> release channel d1;
13> }
14>
RMAN-06005: connected to target database: ORCL (DBID=1142766535)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=16 devtype=SBT_TAPE
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
::CoInitialize(NULL);
hr=m_pConnection.Creat ......
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
mes_co ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......