Re: LMT SYSTEM Tablespace?

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 17 Mar 2004 12:43:57 -0400
Message-ID: <000a01c40c3f$0f903b00$2501a8c0@dazasoftware.com>

I had in this way and don't have problem Is true there was limitations in using new features to system tablespaces.

This is the currect configuration, we have several years without problems. But there were changes in restrictions in new 9i release

DATAFILE 'E:\oraxxx\datafiles\dfl_sys_xxx'

size 200M
REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL CREATE TABLESPACE TBL_USERS DATAFILE 'E:\oraxxx\datafiles\DFL_USER_xxx'

       SIZE 100M
       REUSE AUTOEXTEND ON NEXT  640k MAXSIZE UNLIMITED
       SEGMENT SPACE MANAGEMENT AUTO
       EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 64K ;

Original Message ----- From: "Hemant K Chitale" <hkchital_at_singnet.com.sg> To: <oracle-l_at_freelists.org> Sent: Wednesday, March 17, 2004 12:16 PM Subject: Re: LMT SYSTEM Tablespace?

>
> I use LMT SYSTEM in 9.2.0.2 and 9.2.0.4 on Tru64 and Solaris without any
issues
> [or without having encountered any issues]
>
> Hemant
> At 08:57 AM 17-03-04 -0700, you wrote:
> >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
> >-----------------------------------------------------------------
>
> Hemant K Chitale
> Oracle 9i Database Administrator Certified Professional
> http://hkchital.tripod.com {last updated 24-Jan-04}
> "If you wish to leave your footprints on the sand, do not drag your feet"
>
> ----------------------------------------------------------------
> 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:44:48 CST