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

Oracle AQ ʹÓÃ

 Ëæ×Ų»Í¬Ó¦ÓÃÄ£¿é¼äµÄÏûÏ¢½»»¥ºÍͨÐųÉΪһ¸ö¹Ø¼üµÄ¹¦ÄÜ£¬²¢ÇÒ±äµÃÔ½À´Ô½ÖØÒª¡£OracleÒýÈëÁËÒ»ÖÖÇ¿´óµÄ¶ÓÁлúÖÆ£¬Í¨¹ýËü³ÌÐò¼ä¿ÉÒÔʵÏÖÐÅÏ¢µÄ½»»¥£¬oracle°ÑËü³Æ×÷ΪAQ - Advanced Queuing. ʹÓÃOracle AQ£¬ÎÒÃDz»ÐèÒª°²×°¶îÍâµÄÖмä¼þ£¬ËüÊÇOracleÊý¾Ý¿âµÄÒ»¸ö¹¦ÄÜ×é¼þ£¬Ö»ÒªÄã°²×°ÁËOracle Êý¾Ý¿â¾Í¿ÉÒÔʹÓÃAQÁË¡£½ÓÏÂÀ´·ÖÁ½²¿·ÖÀ´½éÉÜAQµÄʹÓã¬Ê¹ÓÃ֮ǰÎÒÃÇÒª´´½¨QUEUE.
ÎÒÃÇ´´½¨Ò»¸ö×Ô¼ºµÄAQµÄ¹ÜÀí½ÇÉ« "my_aq_adm_role" ºÍ¹ÜÀíÓû§"aqadm"£¬ÔÙ°ÑOracle AQ ¹ÜÀí½ÇÉ« "aq_adminstrator_role" ÊÚȨ¸ø"my_aq_adm_role".
CREATE ROLE my_aq_adm_role;
GRANT aq_adminsistator_role TO my_aq_adm_role
´´½¨Ò»¸öÓû§µÄ½ÇÉ« "my_aq_user_role" ºÍ ÆÕͨÓû§"aquser" ,ÔÙ°ÑOracle AQµÄÓû§½ÇÉ«"aq_user_role"ºÍһЩ»ù±¾²Ù×÷ÐèÒªµÄϵͳȨÏÞÊÚȨ¸ø "my_aq_adm_role"
CREATE ROLE my_aq_user_role;
GRANT CREATE session, aq_user_role TO my_aq_user_role;
EXEC DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE(
privilege => 'ENQUEUE_ANY',
grantee => 'my_aq_user_role',
admin_option => FALSE);
EXEC DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE(
privilege => 'DEQUEUE_ANY',
grantee => 'my_aq_user_role',
admin_option = 'FALSE');
ÏÖÔÚÎÒÃÇ´´½¨ AQ¹ÜÀíÓû§
CREATE USER aqadm IDENTIFIED BY aqadm
DEFAULT TABLESPACE elathen
TEMPORARY TABLESPACE temp;
GRANT my_aq_adm_role TO aqadm;
GRANT connect, resource TO aqadm; ----×¢Ò⣬resource½Çɫһ¶¨ÒªÊÚ¸øuser,Èç¹ûresource½ÇÉ«ÊÚȨ¸ø
my_aq_adm_role, user½«»áʧȥ unlimited tablespace ȨÏÞ
½Ó×ÅΪÎÒÃÇÏÂÃæexample´´½¨ÆÕͨÓû§
CREATE USER aquser IDENTIFIED BY aquser
DEFAULET TABLESPACE elathen
TEMPORARY TABLESPACE temp;
GRANT my_aq_user_role TO aquser;
ÎÒÃǽ«ÔÚÎÒÃǵÚÒ»¸öqueueÖÐʹÓÃobject type¶ø²»ÊÇNUMBER or VARCHAR2×÷Ϊpayload£¬ÕâʹÎÒÃǸüÌù½üʵ¼ÊÓ¦Óá£(payloadÊÇÈκÎÏûÏ¢¶¼Ê¹ÓõÄÒ»ÖÖÊý¾ÝÀàÐͺͽṹ).
ÉÏÃæ×öµÄ¹¤×÷¶¼ÐèÒªÔÚDBAµÄȨÏÞÏÂ×ö£¬ÏÖÔÚÎÒÃÇÇл»µ½AQ¹ÜÀíÔ±
CONNECT aqadm/aqadm
CREATE TYPE queue_message_type AS OBJECT(
no NUBER,
title VARCHAR2(30),
text VARCHAR2(2000));
/
GRANT EXECUTE ON queue_message_type TO my_aq_user


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

ORACLEÖÐÁÙʱÎļþºÍÊý¾ÝÎļþµÄÇø±ð

Õâ¸öÎÊÌâÒÔǰÀ§ÈŹýÎÒ£¬Á½Õߺó׺Ãû¶¼ÊÇ.DBF¡£¼ÇµÃµ±Ê±ºÃÏñÈ¥ÂÛ̳ÉÏ·¢Á˸öÌû×ÓÎÊ£¬²»¹ýºÃ¼¸ÌìûÈ˽â´ð£¬ÎÞÄÎÖ®ÏÂÎҾͰÑÌû×Ó¸ø½áÁË¡£
½ñÌìÕýºÃÔÚÒ»±¾ÊéÖп´µ½Óн²Á½ÕßÇø±ðµÄ£¬ÓÖÈ¥ÍøÉÏËÑÁËËÑ£¬Ð¡×ܽáһϣ¬¼ÇÏÂÀ´¡£
±¾µØ¹ÜÀíµÄÁÙʱ±í¿Õ¼äÊÇ»ùÓÚÁÙʱÎļþµÄ£¬ÕâЩÎļþÓëÆÕͨµÄÊý¾ÝÎļþ·Ç³£ÏàËÆ£¬µ«ËüÃÇ»¹¾ßÓÐÈçÏÂÌØÐÔ£º
ÁÙʱ ......

OracleÊÕ¹ºSunÈôʧ°Ü IBMÊÇ·ñÔÙÅ×éÏé­Ö¦

¡¶¸£²¼Ë¹¡·ÍøÕ¾½üÈÕ·¢±íÎÄÕ³ƣ¬Èç¹û¼×¹ÇÎÄ74ÒÚÃÀÔªÊÕ¹ºSunµÄ¼Æ»®ÓÉÓÚÅ·Ã˵Ä×èÄÓ¶øÒÔʧ°Ü¸æÖÕ£¬Õâ²¢²»»á¸ø¼×¹ÇÎÄ´øÀ´Ì«´óËðʧ£¬µ«È´»áÁîSunÔâÊÜÖØ´´¡£
¼×¹ÇÎÄÊÕ¹ºSunµÄ½»Ò×ÈÔδ»ñµÃÅ·ÃËίԱ»áµÄÅú×¼¡£
Å·ÃË·´Â¢¶Ï¼à¹Ü²¿Ãŵ£ÐÄ£¬¼×¹ÇÎÄÊÕ¹ºSun½«¶ÔSunµÄ¿ªÔ´Êý¾Ý¿âÒµÎñMySQLÔì³É²»ÀûÓ°Ïì¡£¼×¹ÇÎÄÃæ¶ÔÅ·Ã˵ÄÒÉÂDz¢²»Ô¸×ö³öÈà ......

sql server Óë oracle µÄÇø±ð

ÎÒÏÈÅ×שÒýÓñ:      
     
  1.     ¿ª·¢ÐÔ:     SQLSERVER²»ÄÜ,ORACLEÄÜ×°ÔÚUNIXÉÏ      
  2.     ·ÖÇø±í:     SQLSERVER²»Ä ......

ÓÃplsqlµ¼³öOracleÊý¾Ý¿âµÄ±í½á¹¹


1¡¢ÓÃpl/sql developerÖ»µ¼³ö±í½á¹¹£¬²»µ¼³öÊý¾ÝµÄsqlÎļþ
 ´ð£º  TOOLS-> Export Tables È»ºóÑ¡ÔñÖмäµÄ sqlInserts
         ËüÓÐÒ»¸ö where clause ¿ÉÒÔÉèÖõÄ, ¿´µ½Ã»ÓÐ. ÌîÈë rownum < 0 ¾ÍOKÁË.
         »ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ