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

oracleÊý¾Ý¿â±¸·Ýµ¼ÈëҪעÒâµÄ¼¸¸öÎÊÌâ

£¨1£©oracleÊý¾Ý¿â±¸·ÝµÄµ¼Èë¶ÔÊý¾Ý¿âµÄ°æ±¾ÓÐÒªÇó£¬Ò²¼´Ô´Êý¾Ý¿â£¨µ¼³ö²úÉú±¸·ÝµÄÊý¾Ý¿â£©µÄ°æ±¾ÒªºÍÄ¿±êÊý¾Ý¿â£¨µ¼ÈëÊý¾Ý¿â£©µÄ°æ±¾Ò»Ö£¬·ñÔò¿ÉÄܵ¼Öµ¼Èëʧ°Ü¡£
£¨2£©±¸·ÝÖеÄÓû§Ãû£¨Êý¾Ý¿âµ¼³öʱËùʹÓõÄÓû§£©ºÍµ¼ÈëÊý¾Ý¿âµÄÓû§Ãû×îºÃÒ»Ñù£¬ÒòΪÓû§ÃûºÍ±í¿Õ¼äÃüÃûÓйØÏµ£¬Èç¹û²»Ò»Ñù£¬µ¼Èë¾Í²»ÄÜÒ»´ÎÍê³É¡£Ò²¾ÍÊÇÒª°Ñ½Å±¾ºÍÊý¾Ý·ÖΪ2¸ö±¸·ÝÎļþ£¬µ¼ÈëʱÏȵ¼½Å±¾ÔÙµ¼Êý¾Ý¡£
£¨3£©ÓÐ2ÖÖµ¼È뷽ʽ£º
pl/sql¹¤¾ßµ¼È룬ѡÔñ¹¤¾ß²Ëµ¥Ïµĵ¼Èë±í×Ӳ˵¥µÚÒ»¸öÑ¡Ï£¬¸ù¾ÝÐèÒªÉèÖúÃÑ¡Ï»º³å¡¢Ë÷Òý¡¢È¨Ï޵ȣ©£¬È»ºóÑ¡Ôñ¼ÓÔØµÄdmp±¸·ÝÎļþ£¬µãµ¼Èë¼´¿É¡£
dosÃüÁîµ¼È룬´ò¿ªdosÃüÁî´°¿Ú£¬ÊäÈëÏà¹ØµÄoracleµ¼ÈëÃüÁî½øÐе¼È룬ÓÉÓÚÃüÁî±È½Ï¶à£¬ÔÚÕâÀï¾Í²»ÔÚÒ»Ò»ÃèÊö£¬ÓÐÐËȤ¿É²éÔÄÏà¹Ø×ÊÁÏ¡£


Ïà¹ØÎĵµ£º

Oracle 11g 10g ÎÞ·¨Æô¶¯EmµÄ½â¾ö°ì·¨¡£

½â¾öOracle EMÎÞ·¨Æô¶¯
ORACLE 11g, EM ÎÞ·¨Æô¶¯µÄÎÊÌ⣬¿ÉÄÜÊÇIP¸ü¸ÄÁ˵ÄÔ­Òò£¬ËùÒÔÎÒʹÓÃÁËEMCAÃüÁîÖØÐÂÅäÖÃÁËÒ»ÏÂORACLE EM£¬¾ßÌå¹ý³ÌÈçÏ£º
I:\Documents and Settings\geshaoqing>emca -config dbcontrol db -repos recreate
EMCA ¿ªÊ¼ÓÚ 2007-10-12 11:16:40
EM Configuration Assistant 10.2.0.1.0 Õýʽ ......

½ÌÄãÓÃLinuxÍê³ÉOracle×Ô¶¯ÎïÀí±¸·Ý

½ÌÄãÓÃLinuxÍê³ÉOracle×Ô¶¯ÎïÀí±¸·Ý
http://www.cngr.cn/article/63/390/2006/2006071919004.shtml
±¾ÎĵÄÄ¿±êÊÇͨ¹ýÖ´ÐÐÒ»Shell½Å±¾À´Íê³ÉOracleÊý¾Ý¿â×Ô¶¯±¸·ÝµÄÈ«¹ý³Ì£¬¶øÇÒÄܹ»ÔÚµ±Ç°Ä¿Â¼ÏÂÉú³ÉÆäѹËõÎļþ¡£¾ßÌåʵÏÖ²½ÖèÈçÏ£º¡¡¡¡
¡¡¡¡1£®ÒÔOracleÓû§Éí·ÝµÇ¼µ½LinuxϵͳÏ¡£¡¡¡¡
¡¡¡¡2£®½¨Á¢database.srciptÎÄ ......

oracle jobºÅʹÓÃ

µ±ÓÃsubmit½¨JOBʱ£¬JOBIDÓÉϵͳ×Ô´øSEQUENCE£ºsys.JOBSEQÉú³É¡£
Èç¹ûÒ»¶Îʱ¼äºóJOBID¹ý´ó£¬¿ÉÒÔDROP SEQUENCE sys.JOBSEQ;ÔÙÖØ½¨
create sequence JOBSEQ
minvalue 1
maxvalue 999999999999
start with 1
increment by 1
cache 20;
À´ÖØÐ¿ªÊ¼JOBID¡£
¿ÉÒÔÓÃÏÂÃæÓï¾ä¸üÐÂÒѾ­½¨Á¢µÄJOBID£º
UPDATE sys.Job$
SE ......

OracleÖÐÐòÁÐsequence Ó÷¨

 1£© ½¨Á¢ÐòÁÐÃüÁî
    CREATE SEQUENCE [user.]sequence_name
    [increment by n]
    [start with n]
    [maxvalue n | nomaxvalue]
    [minvalue n | nominvalue];
    INCREMENT BY£º Ö¸¶¨ÐòÁкÅÖ®¼äµÄ¼ä¸ô ......

OracleÖÐÔ¼ÊøÊ¹ÓÃ

ÒÔϼ¸ÖÖÔ¼Êø ¡¢²¢ Ò»Ò»Áо٣º
1.Ö÷¼üÔ¼Êø£º
Òª¶ÔÒ»¸öÁмÓÖ÷¼üÔ¼ÊøµÄ»°£¬ÕâÁоͱØÐëÒªÂú×ãµÄÌõ¼þ¾ÍÊÇ·Ö¿Õ
ÒòΪÖ÷¼üÔ¼Êø£º¾ÍÊǶÔÒ»¸öÁнøÐÐÁËÔ¼Êø£¬Ô¼ÊøÎª£¨·Ç¿Õ¡¢²»Öظ´£©
ÒÔÏÂÊÇ´úÂë  Òª¶ÔÒ»¸öÁмÓÖ÷¼ü£¬ÁÐÃûΪid,±íÃûΪemp
¸ñʽΪ£º
alter table ±í¸ñÃû³Æ add constraint Ô¼ÊøÃû³Æ Ôö¼ÓµÄÔ¼ÊøÀàÐÍ £¨ÁÐÃû£©
À ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ