dear Bambang, ada banyak cara untuk bersihin temp tablespace, ini salah satu cara yang bisa dilakukan: 1. waktu mau ngebersihin temp tablespace pastikan tidak ada user yang menggunakan temp tablespace tersebut. cara ngeceknya, bisa pake script ini ================================================================ select CURRENT_USERS, TOTAL_EXTENTS, USED_EXTENTS, FREE_EXTENTS, ADDED_EXTENTS, EXTENT_HITS, FREED_EXTENTS, FREE_REQUESTS, MAX_SIZE, MAX_USED_SIZE, MAX_SORT_SIZE from v$sort_segment; ================================================================== 2. alter tablespace <temp_tablespace_name> offline; 3. alter tablespace <temp_tablespace_name> online; 4.alter tablespace <temp_tablespace_name> coalesce;
smoga membantu ... salam, Irawan ----- Original Message ----- From: "Bambang Irianto" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, August 05, 2005 3:15 PM Subject: [indo-oracle] Tablespace TEMP full > Hi, para pakar oracle, mau tanya nih (masih awam di oracle), saya punya tablespace temp selalu penuh terus. > pertanyaan : > 1. Gimana cara membersihkan Tablespace Temp > 2. Gimana caranya membuat Tablespace Temp baru kemudian mengeset-nya utk memakai Tablespace yg baru sehingga Tablespace yg lama bisa di drop. > > thx atas perhatiannya. > > > --------------------------------- > Start your day with Yahoo! - make it your home page > > [Non-text portions of this message have been removed] > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > > > The contents of this e-mail may be confidential and the unauthorized use, copying, or dissemination of it and any attachments to it, is prohibited. Internet communications are not secure and Dexa Group companies do not, therefore, accept legal responsibility for the contents of this message nor for any damage caused by viruses. The views expressed here do not necessarily represent those of Dexa Group companies. ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12homcsi0/M=362131.6882499.7825260.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1123240676/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
