Should be created as temporary locally managed issuing
the stmt:
create temporary tablespace temp2
tempfile ......
extent management local......
After that, drop the other one.
Regards.
- David Wagoner <dwagoner_at_arsenaldigital.com> wrote:
> What is the best way to convert a dictionary-managed
> TEMP tablespace to
> locally managed?
>
> 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?
>
> Thanks for your advice,
>
>
> david
>
> David B. Wagoner
> Database Administrator
> Arsenal Digital Solutions Worldwide Inc.
> 4815 Emperor Blvd., Suite 110
> Durham, NC 27703
> Tel. (919) 941-4645
> Fax (919) 474-0735
> Email <mailto:dwagoner_at_arsenaldigital.com>
> mailto:dwagoner_at_arsenaldigital.com
> Web <http://www.arsenaldigital.com/>
> http://www.arsenaldigital.com/
>
>
> *** NOTICE ***
> 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.
>
>
ENG. Christian Trassens
Senior DBA
ctrassens_at_yahoo.com
christian_trassens_at_yahoo.es
Phone : +34-699240979
+34-649824704
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at
http://shopping.yahoo.com
or bid at
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Thu Dec 13 2001 - 10:51:26 CST