Home » RDBMS Server » Server Administration » number of temporary tablespaces on one oracle database
number of temporary tablespaces on one oracle database [message #64517] Thu, 03 February 2005 06:18 Go to next message
Sermy O.
Messages: 1
Registered: February 2005
Junior Member
Hi All,

I'm working with oracle database 9.2 on unix(sun)and I would like to know the follow:

The database was installed without problems few weeks ago but now I find out that because another application that was installed, I found that I have 2 tablespaces temporary on my database.

My question is, can this second temporary tablespace affect the oracle database? Where can I find some document that can explain about this problem, work with more that one temporary tablespace?

Thanks in advance,

Sermy

Report message to a moderator

Re: number of temporary tablespaces on one oracle database [message #64520 is a reply to message #64517] Thu, 03 February 2005 08:56 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
there is NO problem in having more than one temporary tablespace.
More information is available in documentation.

Report message to a moderator

Previous Topic: session_per_user
Next Topic: Objects - created by package body
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 04:06:18 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.