Re: Oracle Table Spanning

On Sat, 24 Jan 2004 13:33:20 +0300, "Andrey" <adm_at_mlm.ru> wrote:

>
>"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
>news:a1h4101s430m8nkp6dsp9n2j4k861vi3jk_at_4ax.com...
>> On Sat, 24 Jan 2004 12:35:26 +0300, "Andrey" <adm_at_mlm.ru> wrote:
>>
>> > As original poster noted, he can not change database
>> >and application design, so you helpfull comments are useless at this
>given
>> >case.
>>
>> Partitioning the table doesn't change the table design in any fashion.
>> It is transparent to the application. Your comments are incorrect.
>
>
>Dear Sybrand. Though purpose you comments is clear to me - you want to make
>answer as strict and corresponding to official Oracle documentation as
>possible - in this particular case it is excessive.
>
>Man who questioned stated that he can not change application AND database
>design ("I'm not allowed to manipulate data"). This "and" in aggregate with
>obvious newbie character of question proves he asked about very general
>concept of Oracle capabilities. So, I proposed to turn attention to
>optimization theme, surely good way to questioner to start learning Oracle
>without actually breaking into it.
>
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
>

Apparently you try to hide your ignorance by starting to lecture to experienced users, who are perfectly aware what can and can't be done. You would do wise to apologize.
If you don't want to apologize please provide *sensible* suggestions to what you *think* are the OP's needs.

--
Sybrand Bakker, Senior Oracle DBA