oracle 9iÉý¼¶µ½oracle9208Êý¾Ý¿â
±³¾°£ºÔÚwindows2003serverÉÏ°²×°ÁËOracle9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×îÐµİ²È«²¹¶¡April2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©
(1)µ½metalinkÏÂÔØÉý¼¶Ñ¹Ëõ°ü£¬patchºÅΪ4547809£¬Ñ¹Ëõ°üÃû³ÆΪ p4547809_92080_WINNT.zip£¬for windows 32bit¡£
(2)½âѹËõzip£¬Ï±߰üº¬Ò»¸öDisk1ºÍreadme.htmlÎļþ¡£°²×°Éý¼¶²¹¶¡Ö®Ç°£¬ÔÚ¹ÜÀíÖÐÍ£µôËùÓеÄoracleÏà¹Ø·þÎñ£¬ÔÚÃüÁîÌáʾ·ûÖÐlsnrctl stop,Í£µô¼àÌýÆ÷¡£
(3)ÔÚË«»÷DiskϵÄsetup.exeÇ°£¬È·±£»·¾³±äÁ¿ÖÐÓÐORACLE_HOME±äÁ¿£¬²¢ÒÑÕýÈ·ÉèÖ᣷ñÔò»á³öÏÖ´íÎ󣨴íÎóÍüÁË£©¡£
(4)Ë«»÷setup.exe,×Ô¶¯Éý¼¶µ½9.2.0.8£¬ÃüÁîÌáʾ·ûÌáʾ°²×°Íê³Éºó£¬ËµÃ÷×é¼þÒѾ°²×°ÉÏ¡£
(5)4²½²¢Ã»ÓÐupdate×é¼þ£¬ËùÒÔ»¹ÐèÒªupdate.´ËʱÐèÒª¿ªÆôOracleµÄ·þÎñ£¬×îºÃÊÇÖØÆðµçÄÔ£¬OracleĬÈÏ·þÎñ»á×ÔÆô¶¯¡£
(6)ÒÔsysdbaÉí·ÝµÇ¼Êý¾Ý¿âºó,SQL>startup °²×°oracleÓÐÓÐjvmºÍxdbµÄÓû§È·±£init.oraÖеIJÎÊýSHARED_POOL_SIZE ºÍJAVA_POOL_SIZE Ϊ150m¡£·½·¨ÊDz鿴ÏÖÓÐÁ½¸ö²ÎÊý´óС
SQL>SHOW PARAMETER SHARED_POOL_SIZE
SQL>SHOW PARAMETER JAVA_POOL_SIZE
Èç¹û´óС²»ÊÇ150m,½øÐÐÉèÖãº
SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;
SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;
ÉèÖóɹ¦ºóshutdown immediate¹Ø±ÕÊý¾Ý¿â¡£
(7)ÒÔsysdbaµÇ¼Êý¾Ý¿â
Ö´ÐÐ SQL> STARTUP MIGRATE
SQL> SPOOL patch.log
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catpatch.sql
SQL> SPOOL OFF
spool patch.logÊÇ°Ñ×öÉý¼¶ÈÕÖ¾µ½patch.log£¬¹©ÒÔºó²ì¿´¡£
ÆäÖÐORACLE_BASE\ORACLE_HOME±íʾÄãµÄoracleĿ¼£¬¼ÙÉèoracle°²×°Ä¿Â¼Îªc:\oracle\ora92,ÔòµÚÈý¾äӦΪ£º
SQL>@c:\oracle\ora92\rrdbms\admin\catpatch.sql ÆäÖÐ@±íʾִÐÐÒÔϽű¾¡£
Õâ¸ö¹ý³Ì³ÖÐø´ó¸Å20·ÖÖÓ¡£
(8)Íê³ÉºóshutdownÊý¾Ý¿â£¬È»ºóstartup,Ö´ÐÐÁíÍâÒ»¸ö½Å±¾
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql£¬Íê³ÉºóÉý¼¶²¹¶¡´òÍ꣡£¡
(8)ÖØÆðÊý¾Ý¿â£¬µÇ½ºóselect * from v$version£»¿ÉÒÔ¿´µ½oracleÉýµ½Á
Ïà¹ØÎĵµ£º
Oracleά»¤³£ÓÃSQLÓï¾ä»ã×Ü
ÉÏһƪ / ÏÂһƪ 2008-09-04 11:25:01
²é¿´( 1991 ) / ÆÀÂÛ( 0 ) / ÆÀ·Ö( 0 / 0 )
ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
select * from v$version;
²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_ ......
ÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨
1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ë
select * from opendatasource('MSDAORA', 'Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDB FOR OracleµÄÇý¶¯£¬
×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍ ......
oracle³£ÓÃÊý¾ÝÀàÐÍ
½ñÌìͬÊÂÎÊЩÊý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓеĻ¹ÕæÓеã¼Ç²»ÇåÁË£¬ÓÚÊǾͼòµ¥×ܽáϳ£ÓõÄÊý¾ÝÀàÐÍÒÔ±¸ÈÕºó²éÓÃ
1¡¢Char
¶¨³¤¸ñʽ×Ö·û´®£¬ÔÚÊý¾Ý¿âÖд洢ʱ²»×ãλÊýÌî²¹¿Õ¸ñ£¬ËüµÄÉùÃ÷·½Ê½ÈçÏÂCHAR(L)£¬LΪ×Ö·û´®³¤¶È£¬
ȱʡΪ1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ2000¡£²»½¨ÒéʹÓ㬻ᴠ......
ÏîÄ¿ÖÐÐèҪʹÓõ½°´¹æÔòÉú³ÉÐòÁкţ¬¿ªÊ¼µÄ½â¾ö°ì·¨ÊǸù¾ÝÌõ¼þÈ¡µÃ×î´óIDºÅ½øÐзֽâ+1Ôٺϲ¢µÄ½â¾ö·½°¸£¬ºóÀ´·¢ÏÖÈç¹ûÁ½¸ö¿Í»§Í¬Ê±²Ù×÷µÄʱºò³öÏÖÎÊÌ⣺Ìí¼ÓµÄʱºòIDÒѾ´æÔÚ£¬ÔÒòÊÇ£ºAÓû§ÔÚ·ÃÎÊÈ¡µÃµÚMAX(N)¼Ç¼deID£¬µ«ÊÇ»¹Ã»ÓнøÐÐÔö¼Ó²Ù×÷£¬Õâʱ£¬BÓû§Ò²È¡µÃµÚMAX(N)¼Ç¼deID£¬ÕâÊÇ£Á½øÐÐÌí¼Ó²Ù×÷ͬʱ£¬£ÂҲͬʱ½øÐÐ ......
BLOBת»»ÎªCLOBµÄº¯Êý£¨oracleÖÐÖ´ÐУ©
CREATE OR REPLACE FUNCTION BlobToClob(blob_in IN BLOB) RETURN CLOB AS
v_clob CLOB;
v_varchar VARCHAR2(32767);
v_start PLS_INTEGER := 1;
v_buffer PLS_INTEGER := 32767;
BEGIN
DBMS_LOB.CRE ......