Thank atas masukannya ... Dan juga mau nambahin dikiiiit lagi, "Force Logging" hanya ada mulai versi 9i release 2 (9.2.0....)
verify: SQL> SELECT force_logging FROM V$DATABASE; Bowo --- In [email protected], "Andrew E.K." <[EMAIL PROTECTED]> wrote: > > 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 --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
