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

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 


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸ö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 ......

oracle ·¢Óʼþ´íÎó

ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
                            mes_co ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ