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
I have been using this method in all my 8.0 and 8.1 databases.
Unfortunately, if it is a TEMPORARY Tablespace with a TEMPFILE,
[as I have begun using in 9.2] this command fails.
Then, the only option to either resize the TEMPFILE or resize the TEMPORARY
Segment is to drop and recreate the
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
8.1.6.3
SQL select status,contents,extent_management,allocation_type from
dba_tablespaces where tablespace_name='TEMP';
Extent
STATUSCONTENTS Management ALLOCATIO
- - -- -
ONLINETEMPORARY DICTIONARY USER
SQL alter tablespace TEMP
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
Hi,
Restartup your database if possible.
If you set the datafile autoextent on then you have to recreate that tablespace,
if you set it to not autoextent on for some query may fail due to not enough sorting
space.
Sinardy
-Original Message-
Sent: 12 November 2003 14:24
To: Multiple
Or you can
1. Create another Temporary Tablespace with CREATE TEMPORARY TABLESPACE
new_temporary_tablespace
TEMPFILE . SIZE ... AUTOEXTEND ON NEXT .. MAXSIZE ...
2. Issue ALTER USER TEMPORARY TABLESPACE new_temporary_tablespace commands
3. If running 9.2 with a Default Temporary Tablespace,
Perhaps you could clarify what you mean by
'it grows up faster and faster'.
What exactly does that mean, what script or tool is
showing you that, what is its output, and why is
it a problem?
Restarting the database seems extreme advice for
such a meager description of a problem.
Jared
On Tue,
14 matches
Mail list logo