[58413] in SAPr3-news
Re: Upgrade from 9.2 to 10g
daemon@ATHENA.MIT.EDU (=?ISO-8859-1?Q?Markus_D=F6hr?=)
Thu Nov 9 18:25:30 2006
To: sapr3-news@mit.edu
Date: Fri, 10 Nov 2006 00:24:55 +0100
From: =?ISO-8859-1?Q?Markus_D=F6hr?= <wantbottom@t-online.de>
Message-ID: <4553B8C7.8040905@t-online.de>
Sylvestre wrote:
> Hello
>
> We are going to upgradeour instances from Oracle
> 9.2.0.6 to 10gR2, sap instances
> are in 4.6, a lot have many tablespaces dictionary
> managed and it is asked to me to proove
> that localy managed is better, I'm oracle dba, not
> sap admin so, how I can proof it ?
>
note 214995 (Oracle locally managed tablespaces in the SAP environment)
says:
[...]
General recommendation
Provided that the prerequisites for LMTS (see below) are met, LMTS
should be used instead of DMTS.
[...]
Recommendation for migration, part 1
To be able to fully use locally managed tablespaces, we recommend the
following strategy:
For new SAP installations
Create all tablespaces as LMTS. See also 'LMTS - Guidelines'.
Existing SAP installations with DMTS
New tablespaces should be created as LMTS. Existing dictionary-managed
tablespaces do not need to be changed, they remain (initially) as DMTS.
[...]
Since BRSPACE is now available, you should perform the conversion to
LMTS with this program instead of SAPDBA.
[...]
So according to that note SAP even RECOMMENDS using LMTS. That above
note contains more information about advantages and about migration.
--
Markus
