Home » RDBMS Server » Server Administration » resize temp tablespace
resize temp tablespace [message #64379] Thu, 20 January 2005 08:46 Go to next message
hudo
Messages: 165
Registered: May 2004
Senior Member
Hello, I'd like to resize (make smaller) the temp tablespace which results in
ORA-03279 : there are data above the resize Value

How can the temp tablespace be made smaller. Just started the database, no other actions were performed.

I tried to administer with the Enterprise Manager of the DB 9

Report message to a moderator

Re: resize temp tablespace [message #64380 is a reply to message #64379] Thu, 20 January 2005 09:23 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the usual way you do before.
But with 9i less pain..
You can create a second temp tablespace TEMP2.
set it as default
drop the old temp tablespace temp1 ( your required size).
The given URL might help you. Please have a look.

http://www.idevelopment.info/data/Oracle/DBA_tips/Tablespaces/TBS_3.shtml

Report message to a moderator

Previous Topic: Newbie question regarding patchset installation
Next Topic: how to delete cli.trc file??????????
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 07 14:53:57 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.