Mau nambahin dikit nih,
Pastikan juga database nya tidak dalam mode "Force Logging" karena apapun
perintah nologging akan diabaikan dan hati2 juga menggunakan option NOLOGGING
jika anda memiliki standby database akan menyebabkan corrupt pada standby
database.
Lalu untuk move Table bisa menggunakan command berikut :
ALTER TABLE [Owner].[Table_name] MOVE TABLESPACE [TBS_NAME];
Semoga membantu :)
Toni Iskandar <[EMAIL PROTECTED]> wrote: Terimakasih atas
pencerahannya Pak Bowo....:)
saya ada pertanyaan lagi nih, bisa engga kalo suatu table...tablespacenya di
pindahkan
ke tablespace yg baru. Rencananya table2 yg statusnya nologging akan
dikumpulkan
ke dalam satu tablespace yg baru, kalo bisa gimana caranya...
---------------------------------
Yahoo! Shopping
Find Great Deals on Gifts at Yahoo! Shopping
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
