| oracle temporary tablespace in 8i [message #59097] |
Tue, 28 October 2003 07:16  |
Ravi
Messages: 251
Registered: June 1998
|
Senior Member |
|
|
Hi,
I'm having a problem in table space management,I have much space allocated to oracle temporary table space,I know we cannot create any permanent objects in that table space.My condition is i've to create some huge temporary table for intermediate processing.I don't have much space on my permanent table space.can I create a temporary table and force it to use temporary table space.
your help is highly appreciated
regards,
Ravi
|
|
|
|
| Re: oracle temporary tablespace in 8i [message #59103 is a reply to message #59097] |
Tue, 28 October 2003 09:28  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
|
You cant create permanent objects in 'TEMPORARY' tablespace. You could try, if possible(there are certain conditions), converting the TEMPORARY tablespace into PERMANENT tablespace and create your temp table on it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
