From dwagoner@arsenaldigital.com Thu, 13 Dec 2001 07:56:57 -0800 From: David Wagoner Date: Thu, 13 Dec 2001 07:56:57 -0800 Subject: Convert TEMP tablespace to LMT? Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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    AUTOTEXTLIST \s "E-mail Signature" 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@arsenaldigital.com Web 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.