OraFAQ Forum: Server Administration » How to increase size of temoprary table space

Home » RDBMS Server » Server Administration » How to increase size of temoprary table space

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

How to increase size of temoprary table space [message #52613]

Wed, 31 July 2002 23:42

Surojit
Messages: 2
Registered: March 2002

Junior Member

Please help me to increase the size of temporary tablespace or how to add a data file to temporary tablespace

Report message to a moderator

Re: How to increase size of temoprary table space [message #52620 is a reply to message #52613]

Thu, 01 August 2002 08:54

andrew again
Messages: 2577
Registered: March 2000

Senior Member

The first choice would usually be to just increase the size of the datafile: Find out the name of the datafile(s) in DBA_DATA_FILES.
ALTER DATABASE DATAFILE '/my-path/my-data-file.dbf' RESIZE 100M;

Report message to a moderator

Re: How to increase size of temoprary table space [message #52630 is a reply to message #52613]

Thu, 01 August 2002 21:20

santosh
Messages: 85
Registered: October 2000

Member

Hi,
Try this syntax to increase the size of temp tablespace

alter tablespace temp add Tempfile '[[filename with full path]]'

Remember to use tempfile keyword in add file clause

And normally create the file in the same location as of oracle home directory.

Hope this will help u.

Santosh

Report message to a moderator

Previous Topic:	rename a database
Next Topic:	Re: HELP!!!!!!URGENT!!!!!!!!!!!!!!!!!!!WANT TO DELETE UNUSED UNNECESSARY TABLES FROM DATABASE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 28 22:13:23 CDT 2025