Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µ¼Èë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 ³£ÓÃsqlplusÃüÁî

 
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>shutdow ......

ORACLE ÄÚ´æ¹ÜÀí


Oracle 9i¶¯Ì¬SGA¹ÜÀí
ÔÚOracle 9iÖУ¬¿ÉÒÔÉèÖÃSGA_MAX_SIZE£¬¸Ã²ÎÊýÓÃÒÔ¿ØÖƸ÷»º³å³ØÊ¹ÓõÄÄÚ´æ×ܺͣ¬±¾ÖÊÉÏÊÇÔÚ½ø³ÌÖÐÔ¤ÏÈ·ÖÅäÒ»¶ÎÐéÄâµØÖ·±¸Óöø²»·ÖÅäÎïÀíÄڴ棬ĿµÄÊÇ·ÀÖ¹ºÍ½ø³Ç˽ÓеØÖ·¶ÎµÄ³åÍ»¡£
Ö»Òª×ܵÄSGAÄÚ´æÉèÖò»³¬¹ýSGA_MAX_SIZEµÄÉèÖ㬸ü¸Ä¶¼¿ÉÒÔÁ¢¼´ÉúЧ¡£ÐèҪעÒâµÄÊÇ£¬ÔÚOracle 9iR1ÖУ¬¶¯Ì¬¼õСÄÚ´ ......

ÔÚ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ºÅ