Home » RDBMS Server » Server Administration » Global Temporary Tablespace (10g)
Global Temporary Tablespace [message #357447] Wed, 05 November 2008 06:15 Go to next message
TRaj
Messages: 82
Registered: September 2006
Member

Hi all,

Appreciate if anyone can give me the initial optimal maxsize, when creating a global temporary tablespace.

Thanks.
Re: Global Temporary Tablespace [message #357452 is a reply to message #357447] Wed, 05 November 2008 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> create global temporary table tmp (col integer) storage (initial 10m);
create global temporary table tmp (col integer) storage (initial 10m)
*
ERROR at line 1:
ORA-14451: unsupported feature with temporary table

Does this answer the question?

Regards
Michel
Re: Global Temporary Tablespace [message #357466 is a reply to message #357447] Wed, 05 November 2008 08:10 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
There is no such thing as a global temporary tablespace.
Re: Global Temporary Tablespace [message #357492 is a reply to message #357466] Wed, 05 November 2008 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing
Was so obvious for me that I read it as "global temporary TABLE".

Regards
Michel
Re: Global Temporary Tablespace [message #357580 is a reply to message #357447] Wed, 05 November 2008 22:55 Go to previous messageGo to next message
TRaj
Messages: 82
Registered: September 2006
Member

Hi

Sorry for the confusion. Actually, I used the word "GLOBAL" here is to mean a system wide Temporary tablespace.

That is a default temporary tablespace that has been designated a global temporary tablespace for all users that have not been explicitly defined a temporary tablespace at user creation time.

Thanks.
Re: Global Temporary Tablespace [message #357617 is a reply to message #357580] Thu, 06 November 2008 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So now precise your question.

Regards
Michel
Default Temporary Tablespace [message #357689 is a reply to message #357447] Thu, 06 November 2008 04:50 Go to previous messageGo to next message
TRaj
Messages: 82
Registered: September 2006
Member

Hi Mike,

At the time of creating a default temporary tablespace, what factors (calculations) to consider in setting a good maxsize? I don't want to give maxsize unlimited.

Thanks.
Re: Default Temporary Tablespace [message #357698 is a reply to message #357689] Thu, 06 November 2008 05:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None, I don't put my tablespaces in autoextend mode.

Regards
Michel
Re: Default Temporary Tablespace [message #357978 is a reply to message #357689] Fri, 07 November 2008 08:10 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you're using MASSIZE as a trap in case of runaway datafile growth, then a good definition for MAXSIZE is 'How large can I fford for this file to grow before it will start to interfere with the rest of the server'
Otherwise, it's just a case of how big do you want your datafiles to get. This can be affected by your OS, your backup strategy, and the personal preferences of your sysadmin.
Previous Topic: Difference between V$parameter and V$parameter2
Next Topic: Recover table with deleted records
Goto Forum:
  


Current Time: Sat Dec 03 01:19:19 CST 2016

Total time taken to generate the page: 0.09166 seconds