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
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
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
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
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
[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
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
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
.
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
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
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
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
-
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
, 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
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
15 matches
Mail list logo