RE: LMT SYSTEM Tablespace?

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 17 Mar 2004 11:16:43 -0500

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@xxxxxxxxxxxxxxx

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
  [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephen Andert
  Sent: Wednesday, March 17, 2004 10:58 AM
  To: oracle-l@xxxxxxxxxxxxx
  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@xxxxxxxxxxxxx
  put 'unsubscribe' in the subject line.
  --
  Archives are at //www.freelists.org/archives/oracle-l/
  FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: