Oracle ERP²ÆÎñϵͳ——¹Ì¶¨×ʲú
1 ×ʲúÀàÐÍ
×ʲúÀàÐÍ£º×ʱ¾»¯¡¢CIP¡¢·ÑÓÃÐÔ
×ʱ¾»¯£ºÊÇÖ¸ÐèÒª¼ÆËãÕ۾ɵÄ×ʲú
CIP£ºÊÇÔÚ½¨¹¤³Ì×ʲú£¬Éв»ÐèÕ۾ɣ¬´ýÆä×ʱ¾»¯Ö®ºóÔÙ¿ªÊ¼ÕÛ¾É
·ÑÓÃÐÔ£ºÊDz»¼ÆËãÕ۾ɣ¬¸Ã×ʲúµÄ³É±¾¶¼×÷Ϊ·ÑÓô¦Àí
2 ×ʲúÔö¼Ó
×ʲúÔö¼ÓÓÐÁ½ÖÖ·½Ê½£ºÊÖ¶¯Ôö¼Ó£¬×Ô¶¯Ôö¼Ó¡£
×Ô¶¯Ôö¼ÓÊÇÖ¸ÓÉÆäËûÄ£¿é£¨APÄ£¿é»òPAÄ£¿é£©´«µÝµ½×ʲúÄ£¿é£¬È»ºóÐγɹ̶¨×ʲú¡£
a) ×ʲú×Ô¶¯Ôö¼Ó²½Ö裨APÖÁFA£©
£¨1£©Ó¦¸¶Ä£¿é¼È뷢Ʊ£¬½«·¢Æ±·ÖÅäµ½×ʲú½áËãÕÊ»§£¨Ò»°ãÇé¿öΪ“¹Ì¶¨×ʲú-ÖÐת”Õâ¸ö¿ÆÄ¿£©£¬ÑéÖ¤·¢Æ±£¬²¢Éú³É»á¼Æ·Ö¼¡£
£¨2£©ÔËÐГӦ¸¶ÕÊ¿î¹ÜÀíϵͳ»á¼ÆºËËãÁ÷³Ì”ÇëÇ󣬽«Ó¦¸¶µÄ·¢Æ±£¨¸¶¿î£©µ¼Èë×ÜÕÊ£»
£¨3£©ÔËÐГ´´½¨³ÉÅúÔö¼Ó”ÇëÇ󣬽«Ó¦¸¶Ä£¿éµÄ×ʲú·¢Æ±µ¼Èë×ʲúÄ£¿é¡£
×¢Ò⣺½«Ó¦¸¶µÄ·¢Æ±µ¼Èë×ʲúÄ£¿éµÄÇ°ÌáÌõ¼þÖ®Ò»ÊÇÒªÉèÖúÃ×ʲúÀà±ð¡£²»Í¬µÄ×ʲúÀà±ð¿É¶ÔÓ¦²»Í¬µÄ×ʲú½áËãÕÊ»§ÓëÕ۾ɷ½·¨¡£
£¨4£©ÔÚ×ʲúÄ£¿éÖдò¿ª“×¼±¸³ÉÅúÔö¼Ó”£¬Ñ¡Ôñ´ÓÓ¦¸¶Ä£¿éÖе¼¹ýÀ´µÄ×ʲú£¬½«¶ÓÁиÄΪ“¹ýÕÊ”²¢Ìí¼ÓÏàÓ¦µÄÐÅÏ¢¡£
£¨5£©¹ýÕʳÉÅúÔö¼Ó
ÕâÑù¾ÍÄÜ´Ó×ʲú¹¤×÷̨Öп´µ½ÐÂÔöµÄ×ʲúÁË
to be continue ...
3 ×ʲúÕÛ¾É
a£©Õ۾ɷ½·¨
¹Ì¶¨×ʲúµÄÕ۾ɷ½·¨Ò»°ãÓУº
l ƽ¾ùÄêÏÞ·¨/Ö±Ïß·¨
l ¹¤×÷Á¿·¨
l Ë«±¶Óà¶îµÝ¼õ·¨
l ÄêÊý×ܺͷ¨
¶øÔÚEBSÖУ¬Ê¹ÓõÄÕ۾ɷ½·¨ÀàÐÍΪ£ºÖ±Ïß·¨¡¢¹Ì¶¨±ÈÂÊ·¨¡¢²úÁ¿Õ۾ɷ¨¡£¾ßÌåµÄ¼ÆËã·½·¨¿É×Ô¶¨ÒåÉèÖá£
ÔÚFAÖУ¬Í¨¹ý“ÔËÐÐÕ۾ɔÀ´¼ÇÌáÕ۾ɡ£±¾ÆÚÒ»µ©ÔËÐÐÁËÕÛ¾ÉÖ®ºó£¬ÄÇôÔÚδ¹Ø±Õ±¾ÆÚ¼äµÄÇé¿öϾͲ»ÄÜÔÙ¶Ô×ʲú½øÐÐÊÂÎñ´¦ÀíÁË¡£ÈôÒª½øÐÐÊÂÎñ´¦ÀíÔòÐèÒª»Ø¹öÒÑÔËÐÐÕ۾ɡ£
±¾ÎÄת×Ô:http://blog.vsharing.com/wuxl/A562727.html
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÔÚ´¦ÀíÊý¾Ýʱ·¢ÏÖÒ»¸öÎÊÌ⣬Oracle¶ÔÓÚСÓÚ1µÄСÊý£¬Ð¡ÊýµãÇ°ÃæµÄ0ÊDz»ÏÔʾµÄ¡£
SQL> create table t1_number (num number);
Table created
SQL> insert into t1_number values(0.3268);
1 row inserted
SQL> insert into t1_number values(0.57965686);
1 row inserted
&nb ......
ORACLEÖÐLikeÓëInstrÐÔÄÜ´ó±ÈÆ´
×÷Õߣºµ¤³¼ | ¡¾×ªÔØʱÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡¿
µØÖ·£ºhttp://rdc.taobao.com/blog/dba/html/246_like_instr_performance.html
t±íÖн«½üÓÐ1100ÍòÊý¾Ý£¬ºÜ¶àʱºò£¬ÎÒÃÇÒª½øÐÐ×Ö·û´®Æ¥Å䣬ÔÚSQLÓï¾äÖУ¬ÎÒÃÇͨ³£Ê¹ÓÃlikeÀ´´ïµ½ÎÒÃÇËÑË÷µÄÄ¿±ê¡£µ«¾¹ýʵ¼Ê ......
1.Êý¾Ý¿â¹ÜÀíÏà¹Ø
¡¡¡¡bbed.exe¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Êý¾Ý¿éä¯ÀÀºÍ±à¼¹¤¾ß
¡¡¡¡dbv.exe¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ Êý¾ÝÎļþÂß¼¼ì²â¹¤¾ß
¡¡¡¡exp.exe¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ Êý¾Ýµ¼³ö¹¤¾ß
¡¡¡¡imp.exe¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ Êý¾Ýµ¼È빤¾ß
¡¡¡¡mig.exe¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ Êý¾Ý¿âÒÆÖ²¹¤¾ß
¡¡¡¡nmumigrate.exe¡¡¡¡¡¡¡¡ Da ......
¶ÔÓÚOracle¹¤×÷Á÷µÄÓÅ»¯·½Ê½Ö÷Òª·ÖÁ½´óÀ࣬һÀàÊÇÁ÷³ÌÉè¼ÆÉϵÄÓÅ»¯£¬Ò»ÀàÊÇÊý¾Ý¿âÐÔÄܵÄÓÅ»¯¡£
Á÷³ÌÉè¼ÆÓÅ»¯£º
×ÐϸѡÔñͬ²½´¦ÀíºÍÒì²½´¦Àíģʽ¡£
Èç¹ûÑ¡Ôñͬ²½´¦Àíģʽ£¬ÔòÔÚÌá½»ºóϵͳÁ¢¼´½øÐй¤×÷Á÷´¦Àí£¬ÔÚÁ÷³Ì½áÊøÇ°£¬Ç°¶Ë³ÌÐò½«Ò»Ö±´¦Óڵȴý×´ ̬¡£Èç¹ûÑ¡ÔñÒì²½´¦Àíģʽ£¬³ÌÐòÌá½»¹¤×÷Á÷ºó¿ØÖÆȨÁ¢¼´·µ»Ø£¬¹¤×÷Á÷º ......