重定义怎么用啊！

又顶起来了 :)

汉，前两天刚做了个方案，就是使用先delete，后shrink的操作，当时主要考虑不需要重新rebuild索引，因为rebuild索引时间也很长啊，挺矛盾的，现在看来很危险的；不知道有没有别的办法能够避免rebuild索引；

[quote]原帖由 [i]dhcwenOra[/i] 于 2008-2-29 14:58 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=9725641&ptid=841340][img]http://www.itpub.net/images/common/back.gif[/img][/url]
汉，前两天刚做了个方案，就是使用先delete，后shrink的操作，当时主要考虑不需要重新rebuild索引，因为rebuild索引时间也很长啊，挺矛盾的，现在看来很危险的；不知道有没有别的办法能够避免rebuild索引； [/quote]
online re-organization

rebuild index 是需要的 shrink过程也得维护索引

最后太乱

[font=宋体]SQL> select operation,sql_redo from v$logmnr_contents;[/font]
[font=宋体]OPERATION
--------------------------------
SQL_REDO
--------------------------------------------------------------------------------
DELETE
delete from "YXYUP"."TEST_SHRINK" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'USE
R_QUEUE_PUBLISHERS' and "SUBOBJECT_NAME" IS NULL and "OBJECT_ID" = '4623' and "D
ATA_OBJECT_ID" IS NULL and "OBJECT_TYPE" = 'VIEW' and "CREATED" = TO_DATE('20-JA
N-07', 'DD-MON-RR') and "LAST_DDL_TIME" = TO_DATE('20-JAN-07', 'DD-MON-RR') and
"TIMESTAMP" = '2007-01-20:04:25:26' and "STATUS" = 'VALID' and "TEMPORARY" = 'N'
and "GENERATED" = 'N' and "SECONDARY" = 'N' and ROWID = 'AAACiUAAEAAANLOAAq';[/font]
[font=宋体]INSERT[/font]
[font=宋体]OPERATION
--------------------------------
SQL_REDO
--------------------------------------------------------------------------------
insert into "YXYUP"."TEST_SHRINK"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT
_ID","DATA_OBJECT_ID","OBJECT_TYPE","CREATED","LAST_DDL_TIME","TIMESTAMP","STATU
S","TEMPORARY","GENERATED","SECONDARY") values ('SYS','USER_QUEUE_PUBLISHERS',NU
LL,'4623',NULL,'VIEW',TO_DATE('20-JAN-07', 'DD-MON-RR'),TO_DATE('20-JAN-07', 'DD
-MON-RR'),'2007-01-20:04:25:26','VALID','N','N','N');[/font]
[font=宋体]DELETE
delete from "YXYUP"."TEST_SHRINK" where "OWNER" = 'PUBLIC' and "OBJECT_NAME" = '
USER_QUEUE_PUBLISHERS' and "SUBOBJECT_NAME" IS NULL and "OBJECT_ID" = '4624' and[/font]
[font=宋体]OPERATION
--------------------------------
SQL_REDO
--------------------------------------------------------------------------------
"DATA_OBJECT_ID" IS NULL and "OBJECT_TYPE" = 'SYNONYM' and "CREATED" = TO_DATE(
'20-JAN-07', 'DD-MON-RR') and "LAST_DDL_TIME" = TO_DATE('20-JAN-07', 'DD-MON-RR'
) and "TIMESTAMP" = '2007-01-20:04:25:26' and "STATUS" = 'VALID' and "TEMPORARY"
= 'N' and "GENERATED" = 'N' and "SECONDARY" = 'N' and ROWID = 'AAACiUAAEAAANLOA
Ar';[/font]
[font=宋体]INSERT
insert into "YXYUP"."TEST_SHRINK"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT
_ID","DATA_OBJECT_ID","OBJECT_TYPE","CREATED","LAST_DDL_TIME","TIMESTAMP","STATU[/font]
[font=宋体]OPERATION
--------------------------------
SQL_REDO
--------------------------------------------------------------------------------
S","TEMPORARY","GENERATED","SECONDARY") values ('PUBLIC','USER_QUEUE_PUBLISHERS'
,NULL,'4624',NULL,'SYNONYM',TO_DATE('20-JAN-07', 'DD-MON-RR'),TO_DATE('20-JAN-07
', 'DD-MON-RR'),'2007-01-20:04:25:26','VALID','N','N','N');
[/font]

不错，UPUP

这样的话用 exp ->truncate ->imp  是不是更快呢

*** 作者被禁止或删除 内容自动屏蔽 ***

受教了,谢谢！

长认识了

up

很好的文章,又学到了

我在几G大小的表上作时, 基本没啥问题.

[quote]原帖由 [i]kangoo77[/i] 于 2008-4-20 07:33 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10142960&ptid=841340][img]http://www.itpub.net/images/common/back.gif[/img][/url]
我在几G大小的表上作时, 基本没啥问题. [/quote]


再大点试试

[quote]原帖由 [i]kangoo77[/i] 于 2008-4-20 07:33 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=10142960&ptid=841340][img]http://www.itpub.net/images/common/back.gif[/img][/url]
我在几G大小的表上作时, 基本没啥问题. [/quote]
也并不是说表大就会一定慢，这个也看你的hw的位置的．

学习了

niu

领教了！谢谢

不愧为精华