Dear P'Indra & P'Henri, thanks atas reply-nya. P'Henri, create table tablenew as select * from table_old partisi1 tbs_2005 dst ..bedanya apa dng cara P'Indra ?
Salam/Aly --- On Thu, 12/3/09, Henri Alia Putra <[email protected]> wrote: From: Henri Alia Putra <[email protected]> Subject: RE: External Email : --> Re: [indo-oracle] Backup old data To: "[email protected]" <[email protected]> Date: Thursday, 12 March, 2009, 10:09 PM Dear indra Kenapa tidak dicoba pakai partitioning table aja, kalau dipindah datanya kedalam table yang baru, takutnya ada apalikasi yang masih membaca data2 tersebut, dan akan membongkar lagi aplikasi nya. syaratnya di dalam schema table tersebut tidak ada MV yang membaca table tersebut,kalau ada MV tsb harus di drop dl (lebih lengkap mungkin bisa di cari di metalink) tapi kalau tidak bisa pakai cara di atas, terpaksa buat tabel baru dengan pastisi list/range buat tbs yang dengan nama unik yang menunjukkan tahun (supaya memudahkan maintanance aja),dan siapkan tbs untuk tahun2 yang akan datang baru dibuat partisi table create table tablenew as select * from table_old partisi1 tbs_2005 partisi1 tbs_2006 partisi1 tbs_2007 partisi1 tbs_2008 dst mungkin bisa dipelajari tentang pembuatan partisi. regards Henri From: indo-oracle@ yahoogroups. com [indo-oracle@ yahoogroups. com] On Behalf Of indra syafruddin [indra....@gmail. com] Sent: Thursday, March 12, 2009 9:17 PM To: indo-oracle@ yahoogroups. com Subject: External Email : --> Re: [indo-oracle] Backup old data buat tabelspace di folder yg lain itu, trus untuk tabelnya pindahin tablespace buat data 2005/2006 ke tablespace yang baru. Itu kalau asumsinya tabelnya sudah dipisah kalau belum, ya tinggal buat tabel baru dengan tablespace di folder yang baru, trus pindahin data 2005/2006 ke tabel yang baru itu. On Thu, Mar 12, 2009 at 9:37 AM, aly rmb <aly_...@yahoo. com> wrote: > Salam semua, > sorry baru belajar DBA, > Tolong sharing pengalamannya donk. > misal : ada table isinya dari thn 2005 s/d 2009 > bagaimana cararanya u/ backup/mengeluarkan data thn 2005 s/d 2006 ke folder > lain. > > sebagai informasi, OS = Linux, Oracle = 9i. > klo di cek pake $df -k persentase folder databasenya sudah tinggi. > > sebelumnya terimakasih atas sharingnya. > salam/Aly > > > Get your new Email address! > Grab the Email name you've always wanted before someone else does! > http://mail. promotions. yahoo.com/ newdomains/ aa/ > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this e-mail in whole or in part is strictly prohibited. PT Federal International Finance, which has its seat at North of Jakarta, Indonesia, including its affiliated companies, shall not be liable for the improper or incomplete transmission of the information contained in this e-mail nor for any delay in its receipt or damage to your system. PT Federal International Finance (or its affiliated companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. New Email addresses available on Yahoo! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/ [Non-text portions of this message have been removed]
