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 b
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 t
y, November 14, 2003 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 tab
[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
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
ROTECTED]
> 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
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 TEMPORAR
espond 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_tab
AIL PROTECTED]>
Sent 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,content
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 defa
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, 2
Or you can
1. Create another Temporary Tablespace with CREATE TEMPORARY TABLESPACE
TEMPFILE . SIZE ... AUTOEXTEND ON NEXT .. MAXSIZE ...
2. Issue ALTER USER TEMPORARY TABLESPACE commands
3. If running 9.2 with a Default Temporary Tablespace, ALTER DATABASE
DEFAULT TEMPORARY TABLESPACE
4.
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 r
14 matches
Mail list logo