Pak Candra, Kalo mau coba lewat TOAD begini cara (CMIIW): 1. Login ke DB lewat TOAD dgn user yg punya ROLE DBA 2. Pilih Menu Database -> Administer -> klik Tablespace kemudian akan ditampilkan semua tablespace yg ada 3. Untuk me-Resize atau menambah datafile untuk tablespace tinggal di klik pada nama tablespacenya.
Semoga membantu Ali Imran PT. REASURANSI NASIONAL INDONESIA CIKINI RAYA 99 JAKARTA 10330 62-021-3140009 EXT.114 0817 013 6608 http://aliimranblog.wordpress.com -----Original Message----- From: candra gus <[email protected]> To: [email protected] Date: Mon, 23 Aug 2010 20:58:43 -0700 (PDT) Subject: Re: [indo-oracle] Resize tablespace > > cara nya bos, > aku belum pernah nyoba , > > terima kasih > > > candra > --- Pada Sen, 23/8/10, Ola <[email protected]> menulis: > > Dari: Ola <[email protected]> > Judul: Re: [indo-oracle] Resize tablespace > Kepada: [email protected] > Tanggal: Senin, 23 Agustus, 2010, 2:49 PM > > > > > > > > Â > > > > > > > > > > pake toad lebih mudah > > > > 0L@ > > ----- Original Message ----- > > From: wisnu dwi hidayat > > To: [email protected] > > Sent: Monday, August 23, 2010 1:50 PM > > Subject: Fw: [indo-oracle] Resize tablespace > > > > maaf tadi buat nambahin data file kalo mo resize tinggal ganti aja > > > > ALTER DATABASE DATAFILE '\pathnya\misalnya\PID01.dbf' RESIZE 1024M; > > > > ----- Forwarded Message ---- > > From: candra gus <[email protected]> > > To: [email protected] > > Sent: Mon, August 23, 2010 1:46:35 PM > > Subject: Re: [indo-oracle] Resize tablespace > > > > terima kasih, > > akan saya coba dahulu > > > > candra > > > > --- Pada Sen, 23/8/10, wisnu dwi hidayat <[email protected]> menulis: > > > > Dari: wisnu dwi hidayat <[email protected]> > > Judul: Re: [indo-oracle] Resize tablespace > > Kepada: [email protected] > > Tanggal: Senin, 23 Agustus, 2010, 1:44 PM > > > > Masuk comand prompt panggil sqlplus trus login sebagai sysdba > > > > Misal untuk nama tabel PID > > > > ALTER TABLESPACE PID ADD DATAFILE '\pathnya\folder\PID01.dbf' SIZE 256M > > > > AUTOEXTEND OFF; > > > > smoga membantu, sbenarnya sih saya familiar di linux.. CMIIW > > > > WIsnu > > > > ________________________________ > > > > From: candra gus <[email protected]> > > > > To: [email protected] > > > > Sent: Mon, August 23, 2010 1:35:52 PM > > > > Subject: [indo-oracle] Resize tablespace > > > > Dear all, > > > > mohon bantuannya , bagaimana cara resize tablespace apabila menggunakan > OS > > > > windows > > > > Terima kasih > > > > candra > > > > [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] > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > >
