Re: Clean temporary tablespace

2003-11-19 Thread Yechiel Adar
What version are you on? If less then 9i use the method posted by Hemant K Chitale. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 6:44 AM Well, I mean that OS (w2k) file size of temp01.ora grows

Re: Clean temporary tablespace

2003-11-17 Thread VirVit
Well, I mean that OS (w2k) file size of temp01.ora grows faster... I've setup multimaster replication and as a result got temporary tablespace about 10 Gb. OEM shows that used only about 1Gb, so others 9Gb are gone. I wanna to free them for my purposes. Perhaps you could clarify what you mean

Re: Clean temporary tablespace

2003-11-14 Thread Hemant K Chitale
tablespaces. I have been using it regularly with results. HTH GovindanK On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED] said: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- http

Re: Clean temporary tablespace

2003-11-14 Thread Jared . Still
to form any conclusions Jared GovindanK [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/13/2003 05:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Clean temporary tablespace Jared Though manual says

RE: Clean temporary tablespace

2003-11-14 Thread Stephen.Lee
I got the impression that the poster was thinking segments allocated in temp tablespace must be released, cleaned out, blown away, etc. before something else can come along and use the space. -Original Message- End of the day, read to it through fast, what can I say. I totally blew by

RE: Clean temporary tablespace

2003-11-14 Thread Thater, William
[EMAIL PROTECTED] scribbled on the wall in glitter crayon: I got the impression that the poster was thinking segments allocated in temp tablespace must be released, cleaned out, blown away, etc. before something else can come along and use the space. i was always under the impression that

RE: Clean temporary tablespace

2003-11-14 Thread Stephen.Lee
12:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Clean temporary tablespace [EMAIL PROTECTED] scribbled on the wall in glitter crayon: I got the impression that the poster was thinking segments allocated in temp tablespace must be released, cleaned out, blown away, etc

RE: Clean temporary tablespace

2003-11-14 Thread Mercadante, Thomas F
I agree with you Bill. My temp space is always 80% full. I ignore it until I get a report of a sql error. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, November 14, 2003 1:09 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] scribbled on

Re: Clean temporary tablespace

2003-11-13 Thread GovindanK
. HTH GovindanK On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED] said: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- http://www.fastmail.fm - Sent 0.02 seconds ago -- Please see

Re: Clean temporary tablespace

2003-11-13 Thread Jared . Still
by: [EMAIL PROTECTED] 11/13/2003 03:54 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Clean temporary tablespace 8.1.6.3 SQL select status,contents,extent_management,allocation_type from dba_tablespaces where

Re: Clean temporary tablespace

2003-11-13 Thread GovindanK
PROTECTED] cc: Subject:Re: Clean temporary tablespace 8.1.6.3 SQL select status,contents,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEMP'; Extent STATUSCONTENTS Management ALLOCATIO

RE: Clean temporary tablespace

2003-11-12 Thread Sinardy Xing
recipients of list ORACLE-L Hello! How can I clean temporary tablespace? It grows up faster and faster. -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Clean temporary tablespace

2003-11-12 Thread Hemant K Chitale
- Sent: 12 November 2003 14:24 To: Multiple recipients of list ORACLE-L Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET

Re: Clean temporary tablespace

2003-11-12 Thread Jared Still
, 2003-11-11 at 22:24, VirVit wrote: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network

Clean temporary tablespace

2003-11-11 Thread VirVit
Hello! How can I clean temporary tablespace? It grows up faster and faster. -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com