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]

Kirim email ke