OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » temp01.dbf'

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

temp01.dbf' [message #183020]

Wed, 19 July 2006 03:24

allahmorad
Messages: 18
Registered: June 2006

Junior Member

Hi
(if i can't speak English good,sorry)
In my site , When i want take cold backup
i see temp01.dbf size change from 230,408 KB To 20,733,960 KB
(increase size only in one day)!!
how to decrease size of that file?

thank you

Report message to a moderator

Re: temp01.dbf' [message #183107 is a reply to message #183020]

Wed, 19 July 2006 06:42

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

What is the oracle version?
In 9i and above, you can create a new temp tablespace of your desired size, make it default and drop the old one.

Report message to a moderator

Re: temp01.dbf' [message #183224 is a reply to message #183107]

Thu, 20 July 2006 01:32

allahmorad
Messages: 18
Registered: June 2006

Junior Member

thank you foe help
but how can create new temp file?
my oracle version is 10g

Report message to a moderator

Re: temp01.dbf' [message #183280 is a reply to message #183224]

Thu, 20 July 2006 04:28

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1173

Report message to a moderator

Previous Topic:	Resource Manager: switch back to default group
Next Topic:	Upgrade server to 9.2.0.7 (is it compatible with client 9.2.0.1)?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:53:05 CDT 2024