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

²»°²×°Oracle¿Í»§¶ËÁ¬½ÓOracle

Ô­À´Á¬½ÓORACLE×ÜÊÇҪװORACLE¿Í»§¶Ë£¬Í¦Âé·³µÄ£¬Ò»·½ÃæÒª´øORACLEµÃÅÌ£¬ÁíÒ»·½Ã棬װÕâô´óµÃ¶«Î÷Ò²ÈÃÈ˺ܲ»Ë¬¡£Oracle´Ó10g¿ªÊ¼Ð³öÁËÒ»¸öInstant Client£¬ÊÇÕë¶ÔWINDOWSƽ̨µÄ£¬²»Óð²×°¿Í»§¶Ë¾Í¿ÉÒÔÁ¬½ÓOracleÊý¾Ý¿â¡£Instant ClientÊÇÒ»¸ö½ÏΪÇáÁ¿¼¶µÄ¿Í»§°ü£¬Êµ¼ÊÊÇÒ»¸özipÎļþ£¬40¶àM£¬²»ÐèÒª°²×°£¬Ö±½Ó½âѹËõ£¬¿ÉÒԺͳÌÐòÒ»Æð´ò°ü£¬²»¹ýĿǰ²»ÄÜÁ¬½Ó8.1.7.4֮ǰµÄÊý¾Ý¿â¡£
1¡¢ÏÂÔØÏàÓ¦µÄ³ÌÐò£»
http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html?_template=/ocom/print£¨ÖÐÎĵģ©
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html£¨Ó¢Îĵģ©
2¡¢½«Oracle Instatnt Client½âѹÖÁD:\instantclient
3¡¢½«Oracle ODBC½âѹÖÁD:\instantclient
4¡¢ÉèÖÃϵͳ»·¾³±äÁ¿£»
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK(»òSIMPLIFIED CHINESE_CHINA.ZHS16GBK)
TNS_ADMIN = D:\instantclient
LD_LIBRARY_PATH = D:\instantclient£¨¸Ã±äÁ¿¿ÉÄÜ¿ÉÒÔÊ¡ÂÔ£©
SQL_PATH = D:\instantclient
Oracle_home= D:\instantclient
Path = % Path %; D:\instantclient
5¡¢ÔÚD:\instantclientÖÐÓÃÌí¼ÓÈçÏÂÄÚÈݵÄÎļþ,ÎļþÃûΪtnsnames.ora
 
# tnsnames.ora Network Configuration File: D:\instantclient\tnsnames.ora
# Generated by Oracle configuration tools.
ORB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = local)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orb)
    )
  )
Òª°²×°ODBCµÄ»°ÏÂÔØInstant Client Package – ODBC£¬½âѹµ½D:\instantclient·¾¶Ï£¬È»ºóÔÙÃüÁîÌáʾ·ûÖÐÊäÈëodbc_install.exe¡££¨¼ÇµÃµ±Ç°Ä¿Â¼Ò»¶¨ÒªÊÇodbc_install.exeËùÔÚµÄĿ¼£¬Òª²»»á³ö´í£©
³£ÉèµÄ×Ö·û¼¯£º
Set nls_lang=simplified chinese_china.zhs16cgb231280
Set nls_lang=simplified chinese_china.ZHS16GBK
Set nls_lang=simplified chinese_china.Utf8
 ±¸×¢£º
instantclient-basic-win32-11.1.0.6.0.zip    -Õâ¸öÊÇÖ§³ÖOracle 9i ÒÔÉϵİ棨²»°üÀ¨Oracle9i£©
instantclie


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä

Oracle´´½¨É¾³ýÓû§¡¢½ÇÉ«¡¢±í¿Õ¼ä¡¢µ¼Èëµ¼³ö¡¢...ÃüÁî×ܽá 
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace zfmi_temp
tempfile 'D:\oracle\oradata\zfmi\zfmi_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//tempfile²ÎÊý±ØÐëÓÐ
//´´½¨Êý¾Ý±í¿Õ¼ä
create table ......

OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨

connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶ ......

Ö´ÐÐcommitʱoracle×öÄÄЩ¹¤×÷

COMMITÊÇÒ»¸ö·Ç³£¿ìµÄ²Ù×÷£¬µ±ÎÒÃÇ·¢²¼commitÃüÁîʱ£¬ÕæÕýÀ§Äѵ͝×÷ÒѾ­Íê³É£¬
ÔÚÊý¾Ý¿âÖÐÒѾ­Ö´ÐÐÁËÊý¾Ý¸ü¸Ä£¬ËùÒÔÒѾ­Íê³ÉÁË99%µÄÈÎÎñ£¬ÀýÈ磺ÏÂÁвÙ×÷ÒѾ­²úÉú£º
 
      1.ÔÚSGA(Buffer Cache)ÖÐÒѾ­Éú³ÉÁËundo¿é£»
      2.ÔÚSGA(Buffer Cache)ÖÐÒѾ­Éú³ ......

ÔÚOracleÖвéѯ±íµÄ´óСºÍ±í¿Õ¼äµÄ´óС

ÓÐÁ½ÖÖº¬ÒåµÄ±í´óС¡£Ò»ÖÖÊÇ·ÖÅä¸øÒ»¸ö±íµÄÎïÀí¿Õ¼äÊýÁ¿£¬¶ø²»¹Ü¿Õ¼äÊÇ·ñ±»Ê¹Ó᣿ÉÒÔÕâÑù²éѯ»ñµÃ×Ö½ÚÊý£º
select segment_name, bytes
from user_segments
where segment_type = 'TABLE';
»òÕß
   Select Segment_Name,Sum(bytes)/1024/1024 from User_Extents Group By Segment_Name
ÁíÒ»ÖÖ±íʵ¼ÊÊ¹Ó ......

Oracle blobÀàÐÍ Êµ¼ù

BLOBµÄº¬Òå¡¡¡¡
      BLOB (binary large object)£¬¶þ½øÖÆ´ó¶ÔÏó£¬ÊÇÒ»¸ö¿ÉÒÔ´æ´¢¶þ½øÖÆÎļþµÄÈÝÆ÷¡£
¡¡¡¡ÔÚ¼ÆËã»úÖУ¬BLOB³£³£ÊÇÊý¾Ý¿âÖÐÓÃÀ´´æ´¢¶þ½øÖÆÎļþµÄ×Ö¶ÎÀàÐÍ¡£
¡¡¡¡BLOBÊÇÒ»¸ö´óÎļþ£¬µäÐ͵ÄBLOBÊÇÒ»ÕÅͼƬ»òÒ»¸öÉùÒôÎļþ£¬ÓÉÓÚËüÃǵijߴ磬±ØÐëʹÓÃÌØÊâµÄ·½Ê½À´´¦Àí£¨ÀýÈ磺ÉÏ´«¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ