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

×î½üÔÚ×öOracleÁÙʱ±í¼ÓÔØ ×ªÔØÒ»¸öÒÔ±ã²éѯ

×ªÔØ
DML statements on temporary tables do not generate redo logs for the data changes. However, undo logs for the data 
and redo logs for the undo logs are generated. Data from the temporary table is automatically 
dropped in the case of session termination, either when the user logs off or 
when the session terminates abnormally such as during a session or instance failure 
undo logs for the data and redo logs for the undo logs  Ç°Õß²»ÊÇ·ÅÔÚrollback segmentÖÐÂð?ÔõôÄÜдµ½redo logÖÐÈ¥ÄØ?
¸´£º ÁÙʱ±í´æ·ÅÔÚÄĶù£¿
ÁÙʱ±í¶Ôinsert/selectÐ͵ÄÓ¦ÓúÜÓÐÓᣠ
±ÈÈçÔÚ´¦Àíweb·­Ò³Ê±£¬¿ÉÒÔͨ¹ýÁÙʱ±íÀ´Ä£Äâcache·µ»Ø½á¹û¡£ 
ÏàÓ¦µÄ£¬ 
Èç¹ûÊÇupdate/select or delete selectÐ͵ÄÓ¦ÓÃʹÓÃÁÙʱ±íÊDz»Õ¼¶àÉÙÓÅÊÆµÄ¡£ 
ӦΪËäÈ»Æä²»Ö±½Óдredo£¬µ«»áͨ¹ýundo¼ä½Óдredo¡£ 
¶øinsertµÄundoÆäʵÊÇÓÃ¿Õ°×¿é»ØÐ´£¬¼¸ºõ²»Ð´redo¡£ 
ÏàÓ¦µÄupdate/deleteÐèÒª¶ÔÏà¹Ødb block×öcp undoµÄ²Ù×÷£¨ÌرðÊÇdelete£©£¬¶ÔÓ¦µÄredo¿ªÏúÒ²¶à¶àÁË¡£ 
»Ø¸´£º ÈçºÎÔÚÕû¸ösessionÖÐËø¶¨Ä³¸ö±í£¿-----------------------------7d335b34f403eaContent-Disposition
ÔÚOracle8i»òÒÔÉϰ汾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º 
1¡£»á»°ÌØÓеÄÁÙʱ±í 
    CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>) 
    ON COMMIT PRESERVE ROWS£» 
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í 
    CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>) 
    ON COMMIT DELETE ROWS£» 
   CREATE GLOBAL TEMPORARY TABLE MyTempTable 
Ëù½¨µÄÁÙʱ±íËäÈ»ÊÇ´æÔڵ쬵«ÊÇÄãÊÔÒ»ÏÂinsert Ò»Ìõ¼Ç¼ȻºóÓñðµÄÁ¬½ÓµÇÉÏÈ¥select£¬¼Ç¼Êǿյģ¬Ã÷°×Á˰ɣ¬ÎÒ°ÑÏÂÃæÁ½¾ä»°ÔÙÌùһϣº 
--ON COMMIT DELETE ROWS ˵Ã÷ÁÙʱ±íÊÇÊÂÎñÖ¸¶¨£¬Ã¿´ÎÌá½»ºóORACLE½«½Ø¶Ï±í£¨É¾³ýÈ«²¿ÐУ© 
--ON COMMIT PRESERVE ROWS ˵Ã÷ÁÙʱ±íÊǻỰָ¶¨£¬µ±ÖжϻỰʱORACLE½«½Ø¶Ï±í¡£ 
³åÍ»µÄÎÊÌâ¸ü±¾²»Óÿ¼ÂÇ. 
ÁÙʱ±íÖ»ÊDZ£´æµ±Ç°»á»°(session)Óõ½µÄÊý¾Ý£¬Êý¾ÝÖ»ÔÚÊÂÎñ»ò»á»°ÆÚ¼ä´æÔÚ¡£ 
ͨ¹ýCREATE GLOBAL TEMPORARY TABLEÃ


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âÖÐsysºÍsystemÁ½¸öÓû§µÄÇø±ð

     sysÊÇOracleÊý¾Ý¿âÖÐȨÏÞ×î¸ßµÄÕʺţ¬¾ßÓÐcreate databaseµÄȨÏÞ£¬¶øsystemûÓÐÕâ¸öȨÏÞ£¬sysµÄ½ÇÉ«ÊÇsysdba£¬systemµÄ½ÇÉ«ÊÇsysoper¡£
¡¡¡¡ÆäÓà¾ÍÊÇËûÃÇÁ½¸öÓû§¹²ÓеÄȨÏÞÁË£º
¡¡¡¡startup/shutdown/dbaÁ½¸öÓû§¶¼ÊÇ¿ÉÒÔ¹ÜÀíµÄ¡£
¡¡¡¡Æ½Ê±ÓÃsystemÀ´¹ÜÀíÊý¾Ý¿â¾Í¿ÉÒÔÁË¡£Õâ¸öÓû§µÄȨÏÞ¶Ô ......

Oracle ROLLUPºÍCUBE Ó÷¨

ÔÚ×öÏîÄ¿¾­³£Óöµ½·Ö¿ÆÊÒ¡¢ÈËÔ±½øÐлã×ܵÄÎÊÌ⣬ÔÚORACLEÖжԴËÀàÎÊÌâµÄ´¦ÀíÏ൱·½±ã£¡ÏÂÃæÒÔÏîÄ¿ÖÐÓöµ½µÄʵÀý½øÐÐ˵Ã÷£º
²éѯÓï¾äÈçÏ£º
select f_sys_getsectnamebysectid(a.sectionid) as sectname,
        --a.sectionid,
       f_sys_employin ......

oracle impʱ±¨IMP 00032£¬IMP 00008½â¾ö°ì·¨

oracle impʱ±¨£º
       IMP-00032: SQL statement exceeded buffer length
       IMP-00008: unrecognized statement in the export file
½â¾ö°ì·¨:
   ½«impÓï¾äÓÉ
         imp username/userpass@or ......

ÈçºÎ¼ÓËÙOracle´óÅúÁ¿Êý¾Ý´¦Àí

ÈçºÎ¼ÓËÙ
Oracle
´óÅúÁ¿Êý¾Ý´¦Àí
Ò»¡¢          
Ìá¸ß
DML
²Ù×÷µÄ°ì·¨£º
¼òµ¥ËµÀ´£º
£±¡¢ÔÝÍ£Ë÷Òý£¬¸üкó»Ö¸´.
±ÜÃâÔÚ¸üеĹý³ÌÖÐÉæ¼°µ½Ë÷ÒýµÄÖØ½¨.
£²¡¢ÅúÁ¿¸üУ¬Ã¿¸üÐÂһЩ¼Ç¼ºó¼°Ê±½øÐÐÌá½»¶¯×÷.
±ÜÃâ´óÁ¿Õ¼Óûعö¶ÎºÍ»òÁÙʱ±í¿Õ¼ä.
£³¡¢´´½¨Ò»ÁÙʱ ......

oracle ±¸·Ý,±í¿Õ¼ä¼ì²éshell½Å±¾´úÂë

#!/bin/ksh
#****************************************************************************
#
# (C) Copyright CPIC. 2008
#
# File name:    check_db_alert.sh
# Project:      Database Alerts Check
#
# Parameter : app_name -- name of db application(=ora ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ