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

Oracle ÊÕ¹ºSunÖ®ºóµÄÑÝÒ壺IBM ºÍSAPºÎÈ¥ºÎ´Ó

SunÖÕÓÚµ¹ÏÂÁË£¬Ò»¸ö²»µ«´´Ôì¼¼ÊõÉñ»°£¬¸øÊÀ½çIT¼¼Êõ´øÀ´¸ïÃüÐÔÓ°ÏìµÄ¹«Ë¾µ¹ÏÂÁË£¬ÎÒ»³ÄîËü¡£
ÎÒ¸öÈËÈÏΪORACLEºÍSUNµÄºÏ²¢£¬ÊÇÁ½¼Ò
¹«Ë¾µÄÐÒÊ£¬ORACLE½øÒ»²½ÍêÉÆÁ˲úÆ·Ïߣ¬²¢ÇÒ·ûºÏÁËÄ¿Ç°SaaSºÍÔƼÆËãµÄÇ÷ÊÆ£¬³ÉΪһ¸öÔÚ²úÆ·ÏߺͷþÎñÉÏ¿ÉÒÔºÍIBM½øÐоºÕùµÄ¹«Ë¾£¬¶øSUNµÄ
¼¼Êõ¿ÉÄܻᱻORACLE¹«Ë¾µÄÓªÏúÄÜÁ¦·½·¨£¬Ê¹SUNµÄ¼¼Êõ¸ü¼Ó·¢Ñï¹ã´ó¡£
²»ÐÒµÄÊÇIBMºÍSAP,×î½ü¼¸Ä꣬IBMµÄÖмä¼þºÏ×÷»ï°é
Siebel¡¢PeopleSoft¡¢JDEµÈÏà¼Ì¸øORACLE¹ºÂò£¬¶ø2010ÄêÊÇORACLEÕûºÏÕâЩ¹«Ë¾×î¼ÑÒµÎñʵ¼ù¡¢ÍƳöÐÂÒ»´ú²úÆ·
ORACLE Fusion
ApplicationsµÄʱ¼ä;ORACLE¹«Ë¾ÔÚ¹ýÈ¥¼¸ÄêÊÕ¹ºÓ¦ÓÃÈí¼þ¹«Ë¾µÄЧ¹û½«»áÏÔÏÖ£¬IBMµÄÖмä¼þ½«»á»áÊܵ½³å»÷£¬SaaSµÄ³öÏÖ½«µ¼ÖÂ
IBMµÄ¶ÀÁ¢Èí¼þ¿ª·¢É̵ļõÉÙ£¬ÕâÊÇÒ»¸öÇ¿Õ߸üÇ¿µÄʱ´ú£»¹ýÈ¥IBM²»×öÓ¦ÓÃÈí¼þ¶ø±ÜÃâºÍ¶ÀÁ¢Èí¼þ¿ª·¢É̵IJßÂÔ½«»áÊܵ½Ó°Ïì¡£
¶øSAPÒòΪ¹ÅÀϵÄ
¼¼Êõ£¬²»Á÷ÐеÄÖмä¼þ£¬Á½ÖÖ¿ª·¢ÓïÑԵĵ¼Öµĸ߳ɱ¾ÊµÊ©³É±¾£¬·Ö¸îµÄÊý¾Ý¿âÉè¼ÆµÈ¶àÖÖÔ­Òòµ¼ÖµÄÓû§·ÃÎÊËٶȻºÂýÊƱØÓ°Ïì¿Í»§µÄÑ¡Ôñ£¬²»¹ÜSAPµÄ¹ÜÀí˼
ÏëºÍ×î¼úÒµÎñʵ¼ù¶àôÁìÏÈ£¬ÆóÒµ¹ÜÀíÈí¼þÖÕ¾¿ÊÇÈí¼þ£¬Ò»¸öÔÚÈí¼þ¼¼ÊõÉÏÂäºóµÄ¹«Ë¾ÏòÓÀÔ¶´¦ÓÚ°ÔÖ÷µØλÊǺÜÄѵġ£
ÎÒµÄÒÉÎÊÊÇIBM»á×öÆóÒµ¹ÜÀíÈí¼þÂð£¿Èç¹û²»×ö£¬ÈçºÎÃæ¶Ôoracleһͳ½­ºþµÄ¾ÖÊÆ¡£SAPÈçºÎÃæ¶ÔORACLE Fusion Applications¿ÉÄÜ´øÀ´µÄ³å»÷£¬IBM»áͶ×Ê»òÕß¹ºÂòSAPÂð£¿
´ÓÀíÂÛÉϽ«£¬SAPÁªºÏIBMÔÚIBMÖмä¼þÉÏÖØÐÂʵÏÖSAP Business SuiteÐèÒªµÄʱ¼äÓ¦¸Ã±ÈORACLE×öORACLE Fusion Applications¶Ì£¬µ«ÊÇSAP¿ÉÄܲ»Ô¸ÒâÃæ¶ÔÏÖʵ£¬ÈÎȻҹÀÉ×Ô´óµÄÈÏΪ¿Í»§»áËÀÐÄËúµØµÄÑ¡Ôñ×Ô¼º¡£
IBM×Ô¼ºÈ¥×öÆóÒµ¹ÜÀíÈí¼þÊƱغͶÀÁ¢Èí¼þ¿ª·¢É̲úÉú¾ºÕù£¬ºÃÏñÒ²²»´ó¿ÉÄܲÉÓô˲ßÂÔ£¬¶ø·öÖ²ºÍͶ×ÊÓоºÕùÁ¦µÄ¶ÀÁ¢Èí¼þ¿ª·¢É̾ͳÉΪĿǰΨһµÄÑ¡Ôñ£¬µ«ÊÇ·ÅÑÛÈ«Çò£¬Äܹ»ºÍSAPºÍORACLE¾ºÕùµÄ¹«Ë¾¼¸ºõûÓС£Èç¹ûÓУ¬Î´±Ø½«À´²»±»oracleÊÕ¹º¡£
¿ÉÄÜÖ§³Ö¿ªÔ´ÆóÒµ¹ÜÀíÈí¼þÊÇÒ»¸ö²»´íµÄÑ¡Ôñ£¬Ö§³ÖÒ»¸öÔÚIBMÖмä¼þÉϵĿªÔ´ÆóÒµ¹ÜÀíÈí¼þ¿ÉÒÔʹIBMµÄÖмä¼þ±éµØ¿ª»¨


Ïà¹ØÎĵµ£º

OracleµÄ¾Û´Ø±í

Ë÷Òý¾Û´Ø±í
create cluster emp_dept_cluster
(deptno number(2)) size 1024;
size 1024 ±íʾÿ¸ö¾Û´Ø¼üÖµ¹ØÁª´óÔ¼1024×Ö½ÚµÄÊý¾Ý,
oracle»áÔÚÓÃÕâ¸öÊý¾Ý¿â¿éÉÏͨ¹ýsize¼ÆËã×î¶à¿ÉÒԷŶàÉÙ¸ö´Ø
Èç¹û¿éÊÇ8KB,ÄÇôÕâ¸ö¿éÉÏ×î¶à·Å7¸ö¾Û´Ø¼ü
Ïò¾Û´ØÖзÅÊý¾Ý֮ǰ,ÐèÒªÏȶԾ۴ؽ¨Á¢Ë÷Òý.
create index emp_dept_cluster_id ......

Oracle ·ÖÒ³

<!-- 
@Name£º·ÖÀàͳ¼ÆÃ÷ϸ
@Time£º2010.01.05
@author JZP
--->
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page language="java" import="wfc.service.database.DB"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.Resul ......

ORACLEÊý¾Ý¿â×Ô¶¯±¸·ÝÈÎÎñ

For win:
1¡¢Ð½¨Ò»¸öÅú´¦ÀíÎļþb.bat£¬¸ÃÎļþĿ¼ÏÂÒªÓÐexp.exeÎļþ
    Åú´¦ÀíÎļþÄÚÈÝ£º
  exp userid=user/passfile=i:\db%date:~0,10%.dmp log=i:\db%date:~0,10%.log
2¡¢Ð½¨ÈÎÎñ¹ØÁªb.batÎļþ¼´¿É¡£
For linux:
1¡¢Çе½oracleÓû§ÏÂн¨Ò»¸öÎļþ£¬Èçb.sh  £¬²¢¸³ÓÚ¿ÉÖ´ÐÐȨÏÞ c ......

orale tablespace&datafile oracle±í¿Õ¼ä

ÔÚÇ°ÃæѧϰOracleÊý¾Ý¿â»ù´¡¼Ü¹¹Ê±£¬ÒѾ­Á˽âÁËOracleµÄ´æ´¢½á¹¹£¬Âß¼­ÉÏ£¬OracleµÄÊý¾Ý´æ·ÅÔÚtablespacesÖУ¬ÎïÀíÉÏ´æ·ÅÔÚdatafilesÖС£Ò»¸ötablespaceÖ»ÄÜÊôÓÚÒ»¸öÊý¾Ý¿â(Ò»¸öÊý¾Ý¿â¿É°üÀ¨¶à¸ötablespace)£¬°üÀ¨ÁË1¸ö»ò¶à¸öÊý¾ÝÎļþ¡£Tablespace¿É½øÒ»²½·ÖΪsegments¡¢extentsºÍblocks¡£Ò»¸ödatafileÖ»ÊôÓÚÒ»¸öÊý¾Ý¿âµÄÒ» ......

oracle´ó¶ÔÏó

ÔÚµ±½ñÍøÂçʱ´ú£¬ÎÒÃǶÔÊý¾ÝµÄ´æ´¢ÊÇÔ½À´Ô½¸ß£¬½ö½ö´æ´¢Ð¡ÐÍÎı¾Êý¾ÝÒѾ­Ô¶Ô¶²»¹»ÁË£¬ÏÖÔÚÊý¾Ý¿âÐèÒª´æ´¢Í¼Æ¬¡¢ÊÓƵµÈµÈһЩ¶àýÌåµÄÄÚÈÝ£¬Òò´Ëoracle¸øÎÒÃÇÌṩÁËÒ»ÖÖ´óÀàÐÍÊý¾Ý¿â¶ÔÏóLOB(Large Object),¿ÉÒÔÓÃÓÚ´æ´¢´óÐÍÊý¾Ý¡£
Ò»¡¢´ó¶ÔÏóµÄ4ÖÐÊý¾ÝÀàÐÍ
CLOB       ×Ö·ûLOBÊý¾ÝÀàÐÍ£¬ÓÃÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ