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

ORACLEÖØ½¨ËùÓеÄË÷Òý


declare­
  STR VARCHAR2(400);­
begin­
  -- ÖØ½¨ORACLEË÷Òý­
  FOR TMP_IDX IN (SELECT TABLESPACE_NAME, OWNER, TABLE_NAME, INDEX_NAME­
                    from ALL_INDEXES­
                   WHERE OWNER = 'HNACMS'­
                     AND temporary = 'N'     ­
                     --AND TABLE_NAME = 'K_TASK'              ­
                     --AND TABLESPACE_NAME <> 'HNACMS_INDX'­
                   ORDER BY TABLESPACE_NAME, TABLE_NAME) LOOP­
    STR := 'ALTER INDEX ' || TMP_IDX.OWNER || '.' || TMP_IDX.INDEX_NAME ||­
           ' Rebuild Tablespace HNACMS_INDX';­
    EXECUTE IMMEDIATE STR;­
  END LOOP;­
end;­


Ïà¹ØÎĵµ£º

ORACLE ʹÓÃDBMS_METADATA.GET_DDL»ñÈ¡DDLÓï¾ä

Oracle ÔÚ9iÒԺ󣬿ÉÒÔÀûÓÃDBMS_METADATA.GET_DDL°üµÃµ½Êý¾Ý¿âµÄ¶ÔÏóµÄddl½Å±¾¡£ÈçÏ£¨SQLPLUSÖÐÖ´ÐУ©£º
1. »ñÈ¡µ¥¸öµÄ½¨±í¡¢ÊÓͼºÍ½¨Ë÷ÒýµÄÓï·¨
set pagesize 0
set long 90000
set feedback off
set echo off
spool DEPT.sql
select dbms_metadata. ......

oracle grant connect,resource to user°üÀ¨µÄȨÏÞ

http://hi.baidu.com/aku88168/blog/item/fa727454ec008553564e00e8.html
CONNECT½ÇÉ«£º    --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ   
    
   ALTER    SESSION    --Ð޸ĻỰ   
   CREATE&nbs ......

C#±¸·ÝOracle´úÂë

ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
 /// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <re ......

OracleÊý¾Ý¿âʹÓü°ÃüÃû¹æÔòµÄÏê½â

¹«Ë¾Òѽ¨Á¢µÄ»ò´ý½¨Á¢µÄÍøÕ¾£¬È磺ÖÐÎÄÕ¾£¨CHINA£©£¬¹ú¼ÊÕ¾£¨ALIBABA£©£¬»ªÉÌÕ¾£¨CHINESE£©µÈ¡£
OLPS
Online process system£¬ÔÚÏß´¦Àíϵͳ£¬¼´ÎÒÃǵĻáÔ±¿ÉÒÔä¯ÀÀµÄÍøÕ¾ËùÁ¬½ÓµÄÊý¾Ý¿â£¬Ò²ÊÇÎÒÃÇËù˵µÄǰ̨¡£
BOPS
Back Office process system£¬ºǫ́´¦Àíϵͳ£¬¼´ÎÒÃǵÄÍøÕ¾µÄ·¢²¼ÏµÍ³¡£
BZO
Business Object(?)£¬¹«Ë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ