RE: LMT SYSTEM Tablespace?

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 17 Mar 2004 11:16:43 -0500
Message-ID: <008201c40c3b$3c7faaa0$8459699f@vttaxnet.tax.state.vt.us>

In earlier versions the system tablespace was not supposed to be locally managed. In 9.2.0.x you can and probably should make it locally managed. There are several references on Metalink to explain how to do it. If you can't find them, let me know and I will send them to you privately. I just did this on my production databases.

HTH,
Ruth
rgramolini_at_tax.state.vt.us

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Stephen Andert   Sent: Wednesday, March 17, 2004 10:58 AM   To: oracle-l_at_freelists.org
  Subject: LMT SYSTEM Tablespace?

  I have a vague recollection of not wanting to make the SYSTEM TBS   Locally Managed in earlier releases. I can't recall if that is a real   memory or imagination. In any case, does anyone know of any reason not   to use Locally Managed Tablespaces for all tablespaces in 9.2.0.2+?

  Thanks
  Stephen Andert

---

  Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

  To unsubscribe send email to: oracle-l-request_at_freelists.org   put 'unsubscribe' in the subject line.   --
  Archives are at http://www.freelists.org/archives/oracle-l/   FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Mar 17 2004 - 10:12:42 CST