Re: LMT SYSTEM Tablespace?
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2004 12:43:57 -0400
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@xxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@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
> >-----------------------------------------------------------------
>
> 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@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:
