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...
----- Original Message ----- From: "Yulius Wibowo" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, December 05, 2005 11:02 AM Subject: [indo-oracle] Re: update table pada mode archivelog > > Tablespace: > SQL> CREATE TABLESPACE ts_name DATAFILE '...' SIZE ...M NOLOGGING; > > SQL> ALTER TABLESPACE ts_name NOLOGGING; > > Table: > SQL> CREATE TABLE table_name (col data_type ....) NOLOGGING; > > SQL> ALTER TABLE table_name NOLOGGING; > > Verify: > SQL> select tablespace_name, logging from dba_tablespaces; > > SQL> select table_name, logging from dba_tables; > > Bowo > >> [Non-text portions of this message have been removed] >> > > > > > > > > -- > -----------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 > > > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.362 / Virus Database: 267.13.11/191 - Release Date: 12/2/2005 > > ------------------------ 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/
