Fw: [indo-oracle] shrink lob segment

 

----- Original Message -----

From: Sholehuddin Al-Ayubi

To: indo-oracle@yahoogroups.com

Sent: Tuesday, January 26, 2010 4:21 PM

Subject: [indo-oracle] shrink lob segment

 

Dear all,

DB yg aku maintain punya lob segment yg saat ini sizenya udah sekitar 200GB.
Aku udah lakukan shrink sesuai dengan link dari metalink berikut, tetapi sizenya tidak berkurang.

https://support.oracle.com/CSP/ui/flash.html#tab=KBHome%28page=KBHome&id=%28%29%29,%28page=KBNavigator&id=%28bmDocTitle=ORA-00600%20[16613]%20when%20shrinking%20space%20in%20LOB%20column.&viewingMode=1143&bmDocID=808071.1&from=BOOKMARK&bmDocType=PROBLEM&bmDocDsrc=DOCUMENT%29%29

Berikut synthaxnya:

alter table <table_name> enable row movement;
alter table <table_name> modify LOB (LOB_column_name>) (shrink space);
alter table <table_name> modify LOB (LOB_column_name>) (shrink space cascade);

Mungkin ada teman2 yg pernah mengalami kasus spt ini.
Terimakasih atas bantuannya.

Rgds,
Sholeh

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group

Messages in this topic (1)

Recent Activity:

• New Members 24

Visit Your Group Start a New Topic

--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: indo-oracle-unsubscribe@yahoogroups.com
Website: http://indooracle.wordpress.com
http://www.facebook.com/group.php?gid=51973053515
-----------------------------------------------

Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com

MARKETPLACE

Going Green: Your Yahoo! Groups resource for green living

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___