Aloo Coba di cek pak , archive log destinationnya. Karena proses delete generate banyak archivelog :) contoh : SQL*Plus: Release 10.2.0.2.0 - Production on Wed Sep 10 15:30:10 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /oradata/DB1/arch Oldest online log sequence 1033 Next log sequence to archive 1037 Current log sequence 1037 SQL> cheers, Andrew www.indo-oracletech.com ----- Original Message ---- From: Aji Perdana <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, 10 September 2008 13:18:23 Subject: Re: [indo-oracle] DROP TABLE apakah free up disk space? Terima kasih atas jawaban dan infonya. btw kondisinya begini, saya menaruh data file untuk tablespace dedicated di 1 hardisk -> mount point /oradata sedangkan oracle installationnya di hardisk utama (jadi satu dengan OS) -> hanya 1 mount point / sewaktu delete table kok ukuran sized used di hardisk utama malah membesar yah? any advise? thanks Aji ----- Original Message ---- From: mohammad arief pradipto <[EMAIL PROTECTED] com> To: indo-oracle@ yahoogroups. com Sent: Wednesday, September 10, 2008 9:32:48 AM Subject: Re: [indo-oracle] DROP TABLE apakah free up disk space? Mungkin lebih tepatnya dengan mendrop table akan free up tablespace, tapi ukuran tablespace yang dioccupy di harddisk ngg otomatis berkurang. untuk mengurangi size tablespace di harddisk, dilakukan dengan cara me-resize ukuran datafile di dalam tablespace tersebut dengan perintah RESIZE. CMIIW On 9/10/08, Aji Perdana <aji_perdana@ yahoo.com> wrote: > > Dear Masters, > > Numpang tanya, daripada harus mendelete table yang isinya buanyak (mungkin > ratusan juta row) > apakah dengan DROP TABLE, dapat free up disk space? > mohon advise nya. > > Terima kasih > > BR, > Aji > > [Non-text portions of this message have been removed] > > > -- adipt [EMAIL PROTECTED] com 021 68 535 141 http://adipt. net/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Get your preferred Email name! Now you can @ymail.com and @rocketmail.com http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed]
