Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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³õ²½½Ó´¥Ê±Óöµ½µÄÎÊÌâ¼°½â¾ö°ì·¨

½ñÌìÔÚ»úÆ÷ÉÏ×°Oracle 10g£¬°²×°Íê³ÉÒÔºó³öÏÖ´íÎóÌáʾ¡°ORA-00988: ¿ÚÁîȱʧ»òÎÞЧ¡±£¬È»ºó¾ÍÎÞ·¨½øÈë¿ØÖÆÌ¨½øÐÐÏàÓ¦µÄ²Ù×÷ºÍ¹ÜÀí£¬ÎÒÒÔǰÔÚ°²×°Oracle 9ʱ²¢Ã»ÓгöÏÖ¹ý
Õâ¸ö´íÎó¡£È»ºóÐ¶ÔØºóÖØÐ°²×°£¬ÎÊÌâÒÀ¾É£¬ÕÛÌÚÁ˺ôóÒ»ÕóÖÕÓÚŪÃ÷°×ÊÇÔõôһ»ØÊÂÁË¡£
ÕâÖÖÇé¿öͨ³£·¢ÉúÓÚ´´½¨ Oracle Àý³Ìʱָ¶¨ÁË·ÇÕý³£µÄÈ«¾ÖÊý¾Ý¿ ......

Oracle 10g RACµÄ¸ºÔؾùºâÅäÖÃ

¸ºÔؾùºâÊÇÖ¸Á¬½ÓµÄ¸ºÔؾùºâ¡£RAC
µÄ¸ºÔؾùºâÖ÷ÒªÊÇָлỰÁ¬½Óµ½RACÊý¾Ý¿âʱ£¬ÈçºÎÅж¨
Õâ¸öеÄÁ¬½ÓÒªÁ¬µ½Äĸö½Úµã½øÐй¤×÷¡£ÔÚRACÖУ¬¸ºÔؾùºâ·ÖΪÁ½ÖÖ£¬Ò»ÖÖÊÇ»ùÓÚ¿Í»§¶ËÁ¬½ÓµÄ£¬ÁíÍâÒ»ÖÖÊÇ»ùÓÚ·þÎñÆ÷¶ËµÄ¡£
Ò»¡¢¿Í»§¶Ë¸ºÔؾùºâµÄÅä
ÖÃ
1
¡¢µ±Ç°·þÎñÆ÷ÖеÄÊý¾Ý¿â°æ±¾ÈçÏ£º
SQL> select * from v$version
; ......

Oracle spool Ó÷¨Ð¡½á

ת×Ô£ºhttp://wallimn.javaeye.com/blog/472182
¶ÔÓÚSPOOL
Êý¾ÝµÄSQL£¬×îºÃÒª×Ô¼º¶¨Òå¸ñʽ£¬ÒÔ·½±ã³ÌÐòÖ±½Óµ¼Èë,SQLÓï¾ä
È磺
select
taskindex||'|'||commonindex||'|'||tasktype||'|'||to_number(to_char(sysdate,'YYYYMMDD'))
from ssrv_sendsms_task;
spool
³£ÓõÄÉèÖÃ
set colsep' ';¡¡¡¡¡¡ //ÓòÊä³ö·Ö¸ô·û ......

Oracle blobÀàÐÍ Êµ¼ù

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