Re: upgrade 9.2 to 10.2

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 9 Nov 2006 14:54:37 -0800
Message-ID: <1163112877.075097.229140@i42g2000cwa.googlegroups.com>

Sylvestre wrote:
> Hello
>
> Our SAP instances must be upgraded from 9.2 to
> 10.2, but
> a lot of tablespace are always in dictionary
> managed, and it is
> asked to me to proove that locally is better, I
> need a test case
> to do it, does someone have idea about such a demo
> ?
>
> Thank yu

You can make it appear that in Oracle 10.2 that dictionary managed tablespaces are not supported. Just create the SYSTEM tablespace as locally managed.

See pages 94-95 of "Expert Oracle Database Architecture" by Tom Kyte (pg 95):
"Going forward, the only storage management method you should be using is a locally-managed tablespace. In fact, in Oracle 9i and above, if you create a database using the database configuration assistant (DBCA), it will create SYSTEM as a locally-managed tablespace..."

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Nov 09 2006 - 16:54:37 CST