| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Convert TEMP tablespace to LMT?
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>What is the best way to convert a dictionary-managed TEMP tablespace to
locally managed?
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Here’s my situation, I created an 8.1.7 database with all
dictionary-managed tablespaces.
Then, I converted all tablespaces to locally managed, except SYSTEM and
TEMP. The conversion packaged
refused to convert TEMP to LMT so it seems that I must drop the TEMP tablespace
and re-create it as LMT. My
question is, do I need to create an intermediate, like TEMP2, and point everything
to it while I’m dropping and re-creating TEMP?
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Thanks for your advice,
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>david
<font size=2 color=black
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>
<span
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail
Signature" <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:blue;font-weight:bold'>David B. Wagoner
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
font-style:italic'>Database Administrator<font size=2
color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;
font-family:Arial;color:black;mso-color-alt:windowtext;font-style:italic'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
font-weight:bold'>Arsenal Digital Solutions Worldwide Inc.<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext;font-weight:bold'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>4815 Emperor
Blvd., Suite 110<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Durham, NC
27703<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;mso-color-alt:
windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Tel. (919)
941-4645<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Fax (919)
474-0735<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black;
mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Email <a
href="mailto:dwagoner_at_arsenaldigital.com"><span
style='font-family:"Times New Roman"'>mailto:dwagoner_at_arsenaldigital.com<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>Web <a
href="http://www.arsenaldigital.com/"><span
style='font-family:"Times New Roman"'>http://www.arsenaldigital.com/<font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'> <font
size=2 color=black face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'><span
style="mso-spacerun:
yes">
<span style='font-size:
8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;color:black'>This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, work product or exempt from disclosure
under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail message
from your computer. Thank you.<font
size=1 color=black face=Arial><span style='font-size:8.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial;color:black;mso-color-alt:windowtext'>
<font
color=black> <font
color=black>
Received on Thu Dec 13 2001 - 09:56:57 CST
 |
 |