oracle ÅäÖø߼¶¸´ÖÆ»·¾³Óöµ½µÄÎÊÌâ
1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪviotest.us.oracle.com
3¡¢¶¨Òå»úÆ÷A£º188 »úÆ÷B£º69
4¡¢°´ÕÕ²Ù×÷²½ÖèÍê³Éºó£¬ÔÚ»úÆ÷AÉϲåÈëÊý¾Ýʱ±¨´í
ora-04067:ûÓÐÖ´ÐУ¬stored procedure "wcms.Test$pr"²»´æÔÚ
ora-01085:ÑÓ³Ùrpcµ½“wcms.test$rp.rep_insert"֮ǰµÄ´íÎó
ora-02063:½ô½Ó×Å2 lines(Ô´ÓÚorcl)
5¡¢ÔÚ»úÆ÷AÉϲ鿴dba_repcatlog
select * from dba_repcatlog ·¢ÏÖ±íÖÐÓмǼ£¬ÇÒ״̬ΪreadyºÍawait_callback,ÆäÖУº
ready:±íʾÇëÇó×¼±¸±»Ö´ÐÐ
await_callback:Ö»³öÏÖÔÚÖ÷Ì嶨ÒåÕ¾µãÉÏ£¬±íʾÕýÔڵȴýÆäËûµÄÖ÷Õ¾µãÖ´ÐÐÇëÇó²¢ÇÒ·µ»Ø½á¹û
6¡¢ÔÚ»úÆ÷BÉϲ鿴dba_repcatlog·¢ÏÖBÖмǼµÄ×°Ìá°¸¾ùΪready£¬²¢ÇÒÓëAÖÐawait_callbackµÄ¼Ç¼һһ¶ÔÓ¦¡£
È»ºóÈç¹û³¤Ê±¼ä´¦ÓÚready״̬£¬Ôò¿ÉÒÔÊÖ¶¯Ö´ÐÐdbms_repcat.do_deferred_repcat_admin´æ´¢¹ý³ÌÀ´Ö´ÐÐÇëÇó£¬ÓÚÊÇÔÚ»úÆ÷BÉÏÖ´ÐÐexecute dbms_repcat.do_deferred_repcat_admin(gname=>'mygroup')£¬È»ºódba_repcatlogÖÐÎ޼ǼÁË£¬ÖØÐÂÔÚAÉÏÖ´ÐвåÈëÓï¾ä£¬³É¹¦¡£
ºóÀ´¾¹ý·ÖÎö£¬·¢ÏÖdbms_repcat.do_deferred_repcat_admin('"MYGROUP"', FALSE);µÄjobµÄ¼ä¸ôʱ¼äÊÇ10·ÖÖÓ£¬¾ÍÊÇÔÚÅäÖÃÍêºóÐèÒª¸ôÊ®·ÖÖӲŻáÖ´ÐÐdo_deferred_repcat_admin£¬Ò²¾ÍÊÇ˵Èç¹ûÔÚÊ®·ÖÖÓºóÔÚAÖÐÖ´ÐвåÈëÓï¾äÓ¦¸Ã²»»á³ö´í¡£
ÔÚAÉϲåÈëÊý¾Ý£¬ÔÚBÉϲéѯ½á¹ûÕýÈ·£¬µ«ÊÇÔÚBÉϲåÈëÊý¾Ý£¬È´³ö´í¡£±¨£º
ORA-23326: ûÓÐÒÖÖƶÔÏó×é "PUBLIC"."MYGROUP"
ÍøÉϲé×ÊÁÏ£¬ÄÚÈÝÈçÏ£º
ÅäÖÃÍêºó£¬×´Ì¬Îª QUIESCEDµÄ½áµã±ØÐë±äΪNORMAL²ÅÄÜDML¡£·ñÔòÖ»ÄÜˢжø²»Äܸü¸Ä£¬Èç¹û·¢²¼DMLÔò»áÊÕµ½£º
14:51:04 ">repadmin@rt>insert into test_user.account values (11);
insert into test_user.account values (11)
ORA-23326: ûÓÐÒÖÖƶÔÏó×é "PUBLIC"."REP"
ÔÚ»úÆ÷BÉϲéѯ¸´ÖÆ×éµÄ״̬
select gname,master,status from dba_repgroup;
GNAME &nbs
Ïà¹ØÎĵµ£º
/*
º¯ÊýÃû³Æ:oracle ×Ö·û°´Î»»òº¯Êý
²ÎÊýÔ¼Êø:p1Óëp2µÄ³¤¶È±ØÐëÒ»ÖÂ
*/
create or replace function F_BITOR(p1 in string, p2 in string) return varchar2 is
Result varchar2(16);
t_p number(3);
r_p varchar2(16);
p_p number(3);
c_1 char(1);
c_2 char(1);
beg ......
create table tree_table
(
id number,
pId number,
orderNumber number,
name varchar2(255)
)
select tt.*
from tree_table tt
start with tt.pId = 0
connect by prior tt.id = ttd.pId
order siblings by orderNumber ......
OracleÖÐÌṩһϵÁÐÀàÐÍ£¬Ã¿¸öÀàÐ͵ÄÌصãÈçÏ£º
char£º´æ´¢¹Ì¶¨³¤¶ÈµÄ×Ö·û£¬Èç¹û×Ö·û³¤¶È²»¹»»áÔÚÓұ߲¹¿Õ¸ñ¡£±ÈÈ磺name char£¨10£©£¬µ±¸øname¸³ÖµÎª'zhangsan'ʱ»áÔÚÓұ߲¹³ä2¸ö¿Õ¸ñ¡£charÀàÐ͵ÄÈÝÁ¿Îª1¡«2000B£¬Ã»ÓÐÖ¸¶¨ÔòĬÈϳ¤¶ÈΪ1¡£
varchar2£º´æ´¢³¤¶È¿É±äµÄ×Ö·û£¬ºÍcharÀàÐ͵IJ»Í¬£¬Ëü²»»á×Ô¶¯²¹³ä¿Õ¸ñ£¬ÇÒ¶¨ÒåÊ ......
×÷Óãºmerge into ½â¾öÓÃB±í¸úÐÂA±íÊý¾Ý£¬Èç¹ûA±íÖÐûÓУ¬Ôò°ÑB±íµÄÊý¾Ý²åÈëA±í£»
Óï·¨£º
MERGE INTO [your table-name] [rename your table here]
USING ( [write your query here] )[rename your query-sql and using just like a table]
ON ([conditional expression here] AND [...]...)
WHEN MATHED THEN [here ......