Berikut adalah contoh script / cara untuk Mengecilkan Undo TableSpace dan Temp TableSpace : UNDOTBS dan TEMP :
SQL*Plus: Release 9.2.0.1.0 - Production on Sel Peb 15 14:24:57 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL> show parameter undo_tablespace; NAME TYPE VALUE ------------------------------ ------ ----------- ----------------------------- undo_tablespace string UNDOTBS1 SQL> create undo tablespace undo1 2 datafile 'd:\oracle\oradata\sap3\undo01.dbf' size 10M reuse 3 autoextend on next 5120K maxsize unlimited; Tablespace created. SQL> alter system set undo_tablespace=undo1; System altered. SQL> drop tablespace undotbs1 including contents and datafiles; Tablespace dropped. SQL> create undo tablespace undotbs1 2 datafile 'd:\oracle\oradata\sap3\undotbs01.dbf' size 10M reuse 3 autoextend on next 5120K maxsize unlimited; Tablespace created. SQL> alter system set undo_tablespace=undotbs1; System altered. SQL> drop tablespace undo1 including contents and datafiles; Tablespace dropped. SQL> create temporary tablespace temp2 2 tempfile 'd:\oracle\oradata\sap3\temp2_01.dbf' size 10M reuse 3 autoextend on next 5120K maxsize unlimited; Tablespace created. SQL> alter database default temporary tablespace temp2; Database altered. SQL> drop tablespace temp including contents and datafiles; Tablespace dropped. SQL> create temporary tablespace temp 2 tempfile 'd:\oracle\oradata\sap3\temp01.dbf' size 10M reuse 3 autoextend on next 5120K maxsize unlimited; Tablespace created. SQL> alter database default temporary tablespace temp; Database altered. SQL> drop tablespace temp2 including contents and datafiles; Tablespace dropped. SQL> exit Best Regards, Doddi Priyambodo On Jan 9, 2008 11:27 AM, Moch Firman N <[EMAIL PROTECTED]> wrote: > Dear All, > > Untuk meng-clear tablespace undo cara-nya gimana? Ada yg bisa ngasih > penjelasan..!!! > > Terima kasih, > > Best regards > Moch Firman N > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
