| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Convert TEMP tablespace from datafiles to tempfiles
List,
Would you please explain to me how you are able to get TEMP and LMT
combined together. I use 8.1.7 and it is not allowed.
"Oracle8i DBA Handbook" Loney and Theriault, Osborne Oracle Press, Page
598 NOTE
"If you specify Local in a create tablespace command, you can not
specify a default storage clause, minextents, or temporary. If you use
the create temporary tablespace command to create the tablespace, you
can specify extent_management local."
The tablespace that is being created is a tablespace with type =
temporary not permanent? correct?
Ron
ROR mô¿ôm
>>> JApplewhite_at_austin.isd.tenet.edu 11/06/02 01:39PM >>>
Rich,
If you've got the disk space, do it while the DB is up. Much simpler.
Create a new Temporary LMT - call it NewTemp - with the appropriate tempfiles.
Switch everyone to NewTemp by spooling and executing this and running
the
spooled file:
Select 'Alter User ' || UserName || ' Temporary Tablespace NewTemp ;'
>From DBA_Users;
After a day or two, or when you can determine that no one is using the
old
Temp tablespace, offline and drop Temp.
If you've just got to have the Temp tablespace named Temp, repeat the
above
steps to create a new Temp LMT.
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
JApplewhite_at_austin.isd.tenet.edu
"Jesse, Rich"
<Rich.Jesse_at_qti To: Multiple recipients
of list ORACLE-L
world.com> <ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_fatcity.co Subject: Convert TEMP
tablespace from
m datafiles to tempfiles
11/06/2002
09:56 AM
Please respond
to ORACLE-L
Hey all,
I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd
like to
take the opportunity to convert the datafiles of the TEMP tablespace
to
tempfiles. My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the
working
script.
I've been trying to reason out this task in my head, as I can't find
much
on
MetaLink, and here's what I've got so far:
I don't yet have an arena to try this in. Will users whose assigned
TEMPORARY TABLESPACE is TEMP need to be ALTERed? Anyone have any
comments
on the procedure?
TIA! Rich
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex,WI
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: JApplewhite_at_austin.isd.tenet.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Nov 06 2002 - 14:10:18 CST
 |
 |