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 ÔÚ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. ......
http://hi.baidu.com/aku88168/blog/item/fa727454ec008553564e00e8.html
CONNECT½ÇÉ«£º --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ
ALTER SESSION --Ð޸ĻỰ
CREATE&nbs ......
ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
/// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <re ......
¹«Ë¾Òѽ¨Á¢µÄ»ò´ý½¨Á¢µÄÍøÕ¾£¬È磺ÖÐÎÄÕ¾£¨CHINA£©£¬¹ú¼ÊÕ¾£¨ALIBABA£©£¬»ªÉÌÕ¾£¨CHINESE£©µÈ¡£
OLPS
Online process system£¬ÔÚÏß´¦Àíϵͳ£¬¼´ÎÒÃǵĻáÔ±¿ÉÒÔä¯ÀÀµÄÍøÕ¾ËùÁ¬½ÓµÄÊý¾Ý¿â£¬Ò²ÊÇÎÒÃÇËù˵µÄǰ̨¡£
BOPS
Back Office process system£¬ºǫ́´¦Àíϵͳ£¬¼´ÎÒÃǵÄÍøÕ¾µÄ·¢²¼ÏµÍ³¡£
BZO
Business Object(?)£¬¹«Ë ......