Re: 11i and table partitioning

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Fri, 19 Jul 2002 09:48:34 +0100
Message-ID: <DnQZ8.3320$zX3.2760@news.indigo.ie>

One would not partition without direct and positive confirmation from Oracle support unless your support from Oracle is not important. The possible difference in execution and the different indexes that need to be created to simulate the same behaviour will probably invalidate the 11i schema.

Somebody else is bound to be running a bigger 11i installation and asked Oracle about this. They were probably told no too !

B: 81630 is desupported by Oracle on that platform.

Personally if it wasn't a production system I'd be interested in doing it as a lab experiment.
"Jayaraman Ashok" <ashok_jayaraman_at_yahoo.com> wrote in message news:7ca2852.0207190009.31fa0b3_at_posting.google.com...
> Hi
> The set up is Oracle 11i apps ver.11.5.5 and the database version is
> 8.1.6.3.0. The platform is RS/6000 Aix 4.3.3. The modules are
> GL,AP,AR,OE.I plan to partition a few tables. I have not been able to
> find proper documentation for the effects of partitioning in 11i
> environment. There are some threads that ask the same question but no
> concrete reply from Oracle except for one in which the version was
> 11.0 and Oracle's reply was not supported. A few of my colleagues are
> apprehensive about this as they feel that this may create problems
> with flexfield data. Can somebody guide me on this and also tell
> whether is it all right to partition tables in 11i.
>
> Cheers,
> Ashok
Received on Fri Jul 19 2002 - 03:48:34 CDT