Silahkan dibaca dan dipraktekkan http://www.idevelopment.info/data/Oracle/DBA_tips/Tablespaces/TBS_3.shtml <http://www.idevelopment.info/data/Oracle/DBA_tips/Tablespaces/TBS_3.shtml>
Best regards, Bottie http://www.yusufbottiegaos.com <http://www.yusufbottiegaos.com/> _____ From: Asep Inbisco IT [mailto:[EMAIL PROTECTED] Sent: Sunday, October 29, 2006 10:19 PM To: [email protected] Subject: [indo-oracle] TEMPORARY FILE PADA TABLESPACE Dear Para Master Oracle, please bantu saya punya masalah......ceritanya begini pada suatu hari saya buat query yang ternyata memerlukan resource yang data yang besar sehingga pada saat prosesnya berhenti ditengah jalan dengan error "not enough disk space for temporary file " sehingga menyebabkan harddisk di computer saya full, ternyata setelah saya lihat dengan TOAD pada Tablespace TEMP dengan lokasi di C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORACLE\TEMP01.DBF size nya mencapai 18860 MB . Pertanyaan saya adalah "Apakah file TEMP01.DBF tersebut boleh dihapus?", Kalau tidak boleh dihapus bagaimana cara memperkecil ukuran file tersebut? Salam Asep [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/
