mungkin link ini bisa membantu pak.
http://sulistyoas.wordpress..com/2008/01/03/recreate-temp-tablespace/ pada intinya utk recreate temp tablespace adalah sbb: == Step 1 Create Temporary Tablespace Temp CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE ‘/u01/app/oradata/temp01′ SIZE 10240M AUTOEXTEND OFF, ‘/u01/app/oradata/temp02′ SIZE 10240M AUTOEXTEND OFF, EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; == Step 2 Move Default Database temp tablespace ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2; == Step 3 Drop temp tablespace DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES; == Step 4 Recreate Tablespace Temp CREATE TEMPORARY TABLESPACE TEMP TEMPFILE ‘/u01/app/temp/temp01′ SIZE 10240M AUTOEXTEND OFF, EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; == Step 5 Move Tablespace Temp, back to new temp tablespace ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp; == Step 6 Drop temporary for tablespace temp DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES; semoga membantu. ----- Pesan Asli ---- Dari: Edwin Setiawan <[EMAIL PROTECTED]> Kepada: [email protected] Terkirim: Kamis, 14 Agustus, 2008 11:30:42 Topik: [indo-oracle] hapus datafile temp Selamat siang, Saya ada rencana mindahin datafile temp karea devicenya sudah critical. Klalau misalkan saya buat datafile temp, lain yang di device awal saya langsung remove, bermasalah gak ya? Terima kasih... [Non-text portions of this message have been removed] ___________________________________________________________________________ Bergabunglah dengan orang-orang yang berwawasan, di di bidang Anda! Kunjungi Yahoo! Answers saat ini juga di http://id.answers.yahoo.com/ [Non-text portions of this message have been removed]
