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

dspace windows oracle install

 ½ñÌìÁ˽âÁËһϿªÔ´dspaceÈí¼þ£¬ÏÖ½«°²×°¹ý³Ì×ܽáÈçÏ£º
1¡¢»·¾³ÉèÖÃ
   1.1 ÏÂÔØjdk1.6.x²¢°²×°,°²×°Ê±Ñ¡ÔñĬÈÏ°²×°Â·¾¶¼´¿É
       Ò»°ãΪ C:\Program Files\Java\jdk1.6.0_10
       ÉèÖÃJAVA_HOME,ÉèÖÃCLASSPATHºÍPATH
2¡¢×é¼þ×¼±¸
   2.1 ÏÂÔØ×îаæmaven2.2.1
      http://www.apache.org/dyn/closer.cgi/maven/binaries/apache-maven-2.2.1-bin.zip
      ÏÂÔØÍê½âѹºó·ÅÔÚ%maven%Ŀ¼Ï£¬È»ºóÉèÖÃmavenµÄ»·¾³±äÁ¿
       н¨»·¾³±äÁ¿£º±äÁ¿ÃûM2_HOME ±äÁ¿Öµ%maven%
       ±ÈÈç%maven%ΪD:/maven2.2.1Ôò M2_HOME=D:/maven2.2.1,ͬʱÔÚPATHÖÐÔö ¼Ó%M2_HOME%\bin
   2.2 ÏÂÔØ×îаæapache-ant-1.8.0-bin.zip
      http://ant.apache.org/bindownload.cgi
      ÔØÍê½âѹºó·ÅÔÚ%ant%Ŀ¼ÏÂ,ͬʱÔÚPATHÖÐÔö¼Ó%ant%\bin
   2.3 ÏÂÔØ×îаæoracle10g
    Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
         http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
         http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
         http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip
         http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip
    ÏÂÔغó¸ù¾ÝÌáʾһ²½Ò»²½½øÐа²×°¡£
    °²×°Íê³Éºó£¬µã»÷¿ªÊ¼->ËùÓгÌÐò->Oracle Database 10g Enterprise Edition ->תÖÁÊý¾Ý¿âÖ÷Ò³
    ÊäÈëDBAµÄÓû§ÃûºÍÃÜÂë(Ò²¾ÍÊÇÔÚ°²×°Ê±×Ô¼ºÉèµÄÓû§ÃûºÍÃÜÂë)¡£µÇ¼³É¹¦ºó´´½¨Óû§dspaceºÍÃÜÂëdspace
   2.4 ÏÂÔØoracleµÄÇý¶¯°üojdbc14.jar
     http://www.oracle.com/technology/


Ïà¹ØÎĵµ£º

ORACLE DSI ½éÉÜ

DSIÊÇData Server
InternalsµÄËõд,ÊÇOracle¹«Ë¾ÄÚ²¿ÓÃÀ´ÅàѵOracleÊۺ󹤳ÌʦʹÓõĽ̲Ä.ÓÉÓÚijÖÖÔ­ÒòÁ÷Âä½­ºþ,
Êܵ½ÖÚ¶àOracle°®ºÃÕßµÄ×·Åõ, ²»¹ýÒªÊǹ¦Á¦²»µ½, ÔĶÁ·´¶øÎÞÒæ. DSI3ÊÇOracle 8ϵÁеÄ, DSI4ÊÇOracle 9ϵÁеÄ.
ÕâÑùµÄÎĵµÉÏͨ³£¶¼Ó¡×Å:Oracle Confidential:For internal Use Only.
DSI301 Advanced S ......

Oracle´æ´¢¹ý³ÌʵÀý

×Ô¶¨Ò庯Êý 
--×Ô¶¨Ò庯Êý
CREATE OR REPLACE FUNCTION fn_WFTemplateIDGet
(
    TemplateCategoryID NUMBER,
    OrganID NUMBER,
    TemplateMode NUMBER

RETURN NUMBER
IS
   ......

ORACLEÃâ·Ñ¹«¿ª¿Î

²©Ñå¿Æ¼¼Oracle erpÃâ·Ñ½²×ù
×÷ΪOracle¹«Ë¾¹Ù·½ÊÚȨÅàѵ»ú¹¹£¬²©ÑåOracle erpרҵÈÏ֤ר¼Ò¿Î³ÌÔÚ±±¾©¡¢ÉϺ£Í¬²½¿ªÕ¹Oracle erpÅàѵ¿Î³Ì¡£
Oracleµç×ÓÉÌÎñÌ×¼þ R12 ²ÆÎñÓ¦ÓÃÈí¼þÄܹ»×Ô¶¯»¯²¢¼ò»¯¿Í»§µÄ²ÆÎñÒµÎñÁ÷³Ì£¬°ïÖúÆóÒµ»ñµÃÆóÒµ·¶Î§ÄÚµÄÈÕ³£ÉÌÎñÖÇÄÜ£¬´Ó¶ø×ö³ö¸üÃ÷Öǵľö²ß¡¢¸Ä½øÔËÓª²¢½ÚÔ¼³É±¾¡£Í³Ò»µÄÊý¾ÝÄ£ÐÍÎªË ......

Oracle 11g SECUREFILES


Oracle Êý¾Ý¿â 11gÃæÏò DBA ºÍ¿ª·¢ÈËÔ±µÄÖØÒªÐÂÌØÐÔ:SecureFiles£º
1¡¢SecureFiles£ºÐ LOB 
Á˽âÈçºÎʹÓÃÐÂÒ»´ú LOB£ºSeureFiles¡£SecureFiles ¼¯ÍⲿÎļþºÍÊý¾Ý¿â LOB ·½·¨µÄÓŵãÓÚÒ»Éí£¬¿ÉÒÔ´æ´¢·Ç½á¹¹»¯Êý¾Ý£¬ÔÊÐí¼ÓÃÜ¡¢Ñ¹Ëõ¡¢Öظ´Ïû³ýµÈµÈ¡£ 
Êý¾Ý¿âפÁô BLOBS »ò OS Îļþ 
ÄúÔÚ Oracle Êý¾Ý¿âÖÐ ......

Oracle³£ÓÃÃüÁî

1. ÐÞ¸Äredo log file´óС
SQL> select group#,status from v$log;
SQL> alter database add logfile group 4 'F:\oracle\product\10.2.0\oradata\orcl\REDO04.LOG' size 512m;
SQL> alter system switch logfile;
SQL> select group#,status from v$log;
2. ÐÞ¸Älarge_pool_size´óС
SQL> alter  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ