bisa, tapi truncate table = delete from table_name, (delete semua row) dan tidak bisa di rollback.
On 9/8/06, johny bravo <[EMAIL PROTECTED]> wrote: > > halo, > kalo gara2 syntax delete-nya bisa ga ya?.... > mungkin harus pakai TRUNCATE, bukan DELETE waktu > menghapus isi tabelnya.... > > > --- m Ilhami <[EMAIL PROTECTED] <m.ilhami%40gmail.com>> wrote: > > > Mungkin gara-gara freelists > > http://www.dba-oracle.com/oracle_tips_freelists.htm > > > > On 9/8/06, Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com>> wrote: > > > > > > Mungkin bisa consider pakai Temporary Table nya > > oracle untuk transaksi > > > Anda. > > > Silakan liat disini > > > > > > > > > > http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2213 > > > > > > > > > On 9/8/06, Iqbal Yahoo <[EMAIL PROTECTED] <qbl2110%40yahoo.com.sg> > > <qbl2110%40yahoo.com.sg>> > > > > wrote: > > > > > > > > Dear rekan Oracle > > > > > > > > Mohon bantuannya, > > > > Ceritanya begini. > > > > Diperusahaan tempat saya bekerja ada table yang > > setiap akhir hari > > > > diresumekan, lalu data tersebut didelete. Setiap > > hari data yang masuk > > > > sekitar 400-500ribu record. > > > > Yang jadi masalah adalah total byte table > > tersebut makin hari makin > > > > membesar > > > > (kondisi sekarang 1,8GB). sedangkan apabila saya > > create table as select > > > > dari > > > > table tsb (jumlah sekitar 500rb record total > > bytenya sekitar 30MB). > > > > Pertanyaannya bagaimana agar block yang > > terdelete dapat dipergunakan > > > lagi > > > > pada saat insert ( berdasarkan referensi yg saya > > baca untuk create table > > > > model begini set PCTFREE 5 dan PCTUSED 60 atau > > saya salah set untuk > > > > PCTFREE > > > > & PCTUSEDnya). > > > > > > > > Sebagai info, saya menggunakan oracle 8.17, > > block size di > > > init.ORA-nya8192 > > > > > > > > dan kalau saya eksekusi dengan > > DBMS_SPACE.UNUSED_SPACE, dihasilkan : > > > > total_blocks : 227,731 > > > > total_bytes : 1,865,572,352 > > > > unused_blocks : 1,245 > > > > unused_bytes : 10,199,040 (kenapa Unused > > bytes-nya segini ? ) > > > > > > > > Ini Script untuk create table-nya: > > > > > > > > create table APP.PERFORMANCE > > > > ( > > > > CODE VARCHAR2(5) not null, > > > > D_DATE DATE not null, > > > > CLIENT_ID NUMBER(4) not null, > > > > STATUS VARCHAR2(16) not null, > > > > TRX_TYPE VARCHAR2(8) not null, > > > > TRX_ID VARCHAR2(32) not null, > > > > TIME1 NUMBER(20) null, > > > > TIME2 NUMBER(20) null, > > > > TIME3 NUMBER(20) null, > > > > TIME4 NUMBER(20) null > > > > ) > > > > pctfree 5 pctused 60 initrans 255 > > > > storage > > > > ( initial 16M next 16M freelists 96 > > > > minextents 1 maxextents UNLIMITED pctincrease 0 > > > > ) > > > > tablespace DATA > > > > nologging > > > > / > > > > > > > > Mohon petunjuknya kepada para pakar Oracle. > > > > > > > > Atas bantuannya saya ucapkan terima kasih > > > > Iqbal > > > > > > > > --------------------------------- > > > > Yahoo! Movies - Search movie info and celeb > > profiles and photos. > > > > > > > > [Non-text portions of this message have been > > removed] > > > > > > > > [Non-text portions of this message have been > > removed] > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been > > removed] > > > > > > > > > > > > > > > [Non-text portions of this message have been > > removed] > > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > [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.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
