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]

Kirim email ke