Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¸ß¼¶¸´ÖÆ

 ÔÚ¿ªÊ¼Ö®Ç°£¬ÐèÒª¼òµ¥ËµÃ÷һϣ¬Ä¿Ç°¹«Ë¾Óм¸¸öÏîÄ¿¶¼²ÉÓÃOracle×÷ΪÊý¾Ý¿âƽ̨£¬²¢ÇÒÓеÄÏîĿʹÓõ½ÁËOracleµÄÊý¾Ý¿â¸´ÖƼ¼Êõ£¬ÆäÖÐÒ²Óöµ½ÁËһЩÎÊÌ⣬Òò´ËÔÚÕâÀÎÒ¶ÔOracleµÄ¸´ÖƼ¼Êõ̸һÏÂÎÒ¸öÈ˵ÄÀí½â£¬Ï£ÍûÄܹ»¶Ô²ÉÓÃOracleÊý¾Ý¿âµÄÏîÄ¿×éÓÐËù°ïÖú¡£ÆäÖÐÔÚÎÄÖÐʹÓõ½µÄSQL½Å±¾¶¼ÊǾ­¹ý¼ìÑé¿ÉÒÔÔËÐеġ£
¡¡¡¡Ê ......

C#±¸·ÝOracle´úÂë

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

¾Æµê¹ÜÀíϵͳ——Oracleµ¼ÈëdmpÎļþ

ÏÂÃæÊÇCMDÃüÁî´°¿ÚϵIJÙ×÷£¬¿´¿´ÊÇÔõôµ¼ÈëµÄ¡£
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\oeg2006>imp
Import: Release 9.2.0.1.0 - Production on ÐÇÆÚÈý 11ÔÂ 25 19:24:12 2009
Copyright (c) 1982, 2002, Oracle Corporation.  A ......

Oracle×Ô´úµÄÏ̳߳Ø

µÚÒ»¸öÀࣺ
/**
 *
 * ´æ·ÅoracleÊý¾Ý¿âµÄÁ´½ÓÐÅÏ¢¡£
 *
 * @author ZhongHuiQiang
 *
 */
public interface IOracleDAOInfor {
 String DB_SERVER_HOSET = "localhost";
 String DB_SERVER_NAME = "ppoo";
 String DB_USER_NAME = "system";
 String DB ......

ÔÚlinuxÉÏsilent°²×°oracle¼òÖ±ÊÇÒ»³¡Ø¬ÃÎ

 Parsing command line arguments:
    Parameter "silent" = true
java.lang.ArrayIndexOutOfBoundsException: 2
        at oracle.net.ca.CmdlineArgs.parseArgs(Unknown Source)
        at oracle.net.ca.I ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ