Home » RDBMS Server » Server Administration » temp-tablespaces
temp-tablespaces [message #60060] Tue, 13 January 2004 00:51 Go to next message
Xenofon
Messages: 3
Registered: January 2004
Junior Member
Hi, there,

1) does anybody how i can find out which, if any, tablespace is declared as a temp-tablespace? I could not find any information in the dictionary about this.

2) if there is no explicit temp-tablespace, then the SYSTEM tablespace is functioning also as a temp-tablespace (as I have read in the documentation). What part of the SYSTEM tablespace would then be used as a temp-tablespace? Say 50% of it, or what?

Thanks in advance for the help,

Xenofon

Report message to a moderator

Re: temp-tablespaces [message #60063 is a reply to message #60060] Tue, 13 January 2004 02:47 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. please look here
2. I beleive it will to use the maximum available.
having system tablespace as TEMP is NOT RECOMMENDED.

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: IMP disregards first character of commit in .dmp
Next Topic: Instalation of Oracle 8.1.7 on Solaris 8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:38:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.