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

OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È

OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È
1¡¢Ç°ÑÔ
    ĿǰËùÓÐʹÓÃOracle×÷ΪÊý¾Ý¿âÖ§³Åƽ̨µÄÓ¦Ó㬴󲿷ÖÊý¾ÝÁ¿±È½ÏÅÓ´óµÄϵͳ£¬¼´±íµÄÊý¾ÝÁ¿Ò»°ãÇé¿ö϶¼ÊÇÔÚ°ÙÍò¼¶ÒÔÉϵÄÊý¾ÝÁ¿¡£
    µ±È»ÔÚOracleÖд´½¨·ÖÇøÊÇÒ»ÖÖ²»´íµÄÑ¡Ôñ£¬µ«Êǵ±Äã·¢ÏÖÄãµÄÓ¦ÓÃÓжàÕÅ±í¹ØÁªµÄʱºò£¬²¢ÇÒÕâЩ±í´ó²¿·Ö¶¼ÊDZȽÏÅӴ󣬶øÄã¹ØÁªµÄʱºò·¢ÏÖÆäÖеÄijһÕÅ»òÕßij¼¸ÕÅ±í¹ØÁªÖ®ºóµÃµ½µÄ½á¹û¼¯·Ç³£Ð¡²¢ÇÒ²éѯµÃµ½Õâ¸ö½á¹û¼¯µÄËٶȷdz£¿ì£¬ÄÇôÕâ¸öʱºòÎÒ¿¼ÂÇÔÚOracleÖд´½¨“ÁÙʱ±í”¡£
    ÎÒ¶ÔÁÙʱ±íµÄÀí½â£ºÔÚOracleÖд´½¨Ò»ÕÅ±í£¬Õâ¸ö±í²»ÓÃÓÚÆäËûµÄʲô¹¦ÄÜ£¬Ö÷ÒªÓÃÓÚ×Ô¼ºµÄÈí¼þÏµÍ³Ò»Ð©ÌØÓй¦ÄܲÅÓõ쬶øµ±ÄãÓÃÍêÖ®ºó±íÖеÄÊý¾Ý¾ÍûÓÃÁË¡£OracleµÄÁÙʱ±í´´½¨Ö®ºó»ù±¾²»Õ¼Óñí¿Õ¼ä£¬Èç¹ûÄãûÓÐÖ¸¶¨ÁÙʱ±í£¨°üÀ¨ÁÙʱ±íµÄË÷Òý£©´æ·ÅµÄ±í¿ÕµÄʱºò£¬Äã²åÈëµ½ÁÙʱ±íµÄÊý¾ÝÊÇ´æ·ÅÔÚORACLEϵͳµÄÁÙʱ±í¿Õ¼äÖУ¨TEMP£©¡£
2¡¢ÁÙʱ±íµÄ´´½¨
    ´´½¨OracleÁÙʱ±í£¬¿ÉÒÔÓÐÁ½ÖÖÀàÐ͵ÄÁÙʱ±í£º»á»°¼¶µÄÁÙʱ±íºÍÊÂÎñ¼¶µÄÁÙʱ±í¡£
    1£©»á»°¼¶µÄÁÙʱ±íÒòΪÕâÕâ¸öÁÙʱ±íÖеÄÊý¾ÝºÍÄãµÄµ±Ç°»á»°ÓйØÏµ£¬µ±Ä㵱ǰSESSION²»Í˳öµÄÇé¿öÏ£¬ÁÙʱ±íÖеÄÊý¾Ý¾Í»¹´æÔÚ£¬¶øµ±ÄãÍ˳öµ±Ç°SESSIONµÄʱºò£¬ÁÙʱ±íÖеÄÊý¾Ý¾ÍÈ«²¿Ã»ÓÐÁË£¬µ±È»Õâ¸öʱºòÄãÈç¹ûÒÔÁíÍâÒ»¸öSESSIONµÇ½µÄʱºòÊÇ¿´²»µ½ÁíÍâÒ»¸öSESSIONÖвåÈëµ½ÁÙʱ±íÖеÄÊý¾ÝµÄ¡£¼´Á½¸ö²»Í¬µÄSESSIONËù²åÈëµÄÊý¾ÝÊÇ»¥²»Ïà¸ÉµÄ¡£µ±Ä³Ò»¸öSESSIONÍ˳öÖ®ºóÁÙʱ±íÖеÄÊý¾Ý¾Í±»½Ø¶Ï£¨truncate table£¬¼´Êý¾ÝÇå¿Õ£©ÁË¡£»á»°¼¶µÄÁÙʱ±í´´½¨·½·¨£ºCreate Global Temporary Table Table_Name(Col1 Type1,Col2 Type2...) On Commit Preserve Rows£»¾ÙÀýcreate global temporary table Student(Stu_id Number(5),Class_id  Number(5),Stu_Name Varchar2(8),Stu_Memo varchar2(200)) on Commit Preserve Rows ;
    2£©ÊÂÎñ¼¶ÁÙʱ±íÊÇÖ¸¸ÃÁÙʱ±íÓëÊÂÎñÏà¹Ø£¬µ±½øÐÐÊÂÎñÌá½»»òÕßÊÂÎñ»Ø¹öµÄʱºò£¬ÁÙʱ±íÖеÄÊý¾Ý½«×ÔÐб»½Ø¶Ï£¬ÆäËûµÄÄÚÈݺͻỰ¼¶µÄÁÙʱ±íµÄÒ»Ö£¨°üÀ¨Í˳öSESSIONµÄʱºò£¬ÊÂÎñ¼¶µÄÁÙʱ±íÒ²»á±»×Ô¶¯½Ø¶Ï£©¡£ÊÂÎñ¼¶ÁÙʱ±íµÄ´´½¨·½·¨£ºCreate Global Temporary Table Table_Name(Col1 Type1,Col2 Type2...) On Commit Delete Rows£»¾ÙÀý£ºcreate global temporary table Classes(Class_id Number(5),Class_Name Varchar2(8),Clas


Ïà¹ØÎĵµ£º

oracle 10g ´íÎó ORA 01653 µÄ½â¾ö¹ý³Ì

ÔçÉÏÓû§·´Ó¦ÔÚ²Ù×÷ÓÃÓÑNCʱ±¨´í ORA-01653 £¬ÏêϸÐÅÏ¢£ºORA-01653: ±í NCV35.GL_DETAIL ÎÞ·¨Í¨¹ý 1024 (ÔÚ±í¿Õ¼ä NNC_DATA01 ÖÐ) À©Õ¹¡£
ÔÚÈÕÖ¾Îļþ F:\oracle\product\10.2.0\admin\CUTC\bdump\alert_cutc.logÖУ¬³öÏÖ
Thu Mar 04 10:59:21 2010
ORA-1653: unable to extend table NCV35.GL_DETAIL by 1024 in&nb ......

oracle Öеĵ¼Èëµ¼³ö

exp document/document2009@document owner=document rows=y compress=y buffer=65536 feedback=100000 file=D:\document.dmp log=D:\document.log
exp whd/whd2009@whddb owner=whd rows=y compress=y buffer=65536 feedback=100000 file=D:\whd.dmp log=D:\whd.log
imp document/document2009@document fromuser=docume ......

Oracleѧϰ±Ê¼ÇһʵÀý


Oracleѧϰ±Ê¼ÇһʵÀý
             ——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
 
Oracleѧϰ±Ê¼ÇһʵÀý
Oracleѧϰ±Ê¼Ç¶þ´æ´¢
Oracleѧϰ±Ê¼ÇÈý·½°¸
ʵÀý
     ÔÚOracleºÍSqlServerÖж¼ÓÐʵÀýһ˵£¬µ«ÕâÁ½¸öʵÀýÊDz»Í¬µÄ¡£
     ÔÚSql ......

oracle´æ´¢¹ý³Ì´úÂëʵÀý

1¡¢ÓÃÀ´²åÈë´óÁ¿²âÊÔÊý¾ÝµÄ´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE INSERTAMOUNTTEST
(
ST_NUM        IN     NUMBER,
ED_NUM        IN     NUMBER
)
IS
BEGIN
declare
     ......

ÔÚIBM AIXÉϰ²×°Oracle RAC (RS/6000)

±¾Îijö×Ô “inthirties£¨ÄÐÈËÈýÊ®£©”²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦£¬Î´¾­×÷ÕßÐí¿É×ªÔØ£¬±Ø×·¾¿·¨ÂÉÔðÈΡ£
ÔÚIBM AIXÉϰ²×°Oracle RAC (RS/6000)
Ä¿µÄ
´ËÎĵµÏò¶ÁÕßÌṩÈçºÎ°²×°Ò»¸öȺ¼¯£¬°²×°RAC£¬²¢ÔÚIBM AIX HACMP/ES (CRM) 4.4.xÉÏÆô¶¯Ò»¸öȺ¼¯Êý¾Ý¿âµÄÊÖ°ÑÊÖÖ¸µ¼Êֲᣬ¶ÔÓÚ¹ØÓÚÈκÎÕâЩ²½ÖèµÄÆäËü½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ