<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: problem with max extents oracle in Operating System - HP-UX</title>
    <link>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471017#M775337</link>
    <description>As of Oracle 7.3, you can define unlimited extents :&lt;BR /&gt;alter index ... storage (maxextents unlimited);&lt;BR /&gt;&lt;BR /&gt;This will fix your problem. Then you can have a deeper look to set more adequate next extent size.&lt;BR /&gt;&lt;BR /&gt;However, the name of segment you mention looks like a rollback segment. If it is right consider dropping it and recreate it.&lt;BR /&gt;&lt;BR /&gt;Regards</description>
    <pubDate>Wed, 06 Dec 2000 14:13:09 GMT</pubDate>
    <dc:creator>Bruno DESQUESNE</dc:creator>
    <dc:date>2000-12-06T14:13:09Z</dc:date>
    <item>
      <title>problem with max extents oracle</title>
      <link>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471015#M775335</link>
      <description>&lt;BR /&gt;&lt;BR /&gt; I have east problem with oracle 7,3,2,3 I cannot extend but indice, that I can do? and as I can do it.&lt;BR /&gt;&lt;BR /&gt;   This is the error :&lt;BR /&gt;he following database error has occurred: ORA-01632: max # extents (505) reached in index CHEMLMS.RS1&lt;BR /&gt;              &lt;BR /&gt;     Thanks in advance</description>
      <pubDate>Wed, 06 Dec 2000 13:45:54 GMT</pubDate>
      <guid>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471015#M775335</guid>
      <dc:creator>Mauro Zabalet</dc:creator>
      <dc:date>2000-12-06T13:45:54Z</dc:date>
    </item>
    <item>
      <title>Re: problem with max extents oracle</title>
      <link>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471016#M775336</link>
      <description>Hi Mauro.&lt;BR /&gt;If you have access as database administrator,&lt;BR /&gt;you should be able to fix this.&lt;BR /&gt;You should enhance the next parameter by factor 20 and change the maxextents.&lt;BR /&gt;Open the svrmgrl and do the connect internal.&lt;BR /&gt;Or open sqlplus as system/passwd.&lt;BR /&gt;Then type as shown in sample :&lt;BR /&gt;alter index owner.indexname storage (next ..M maxtextents 515 )&lt;BR /&gt;;&lt;BR /&gt;&lt;BR /&gt;another thing is to make a note of the storage&lt;BR /&gt;parameters of that index, drop it, resize the parameters and rebuild it.&lt;BR /&gt;if you need more info, let me know.&lt;BR /&gt;Rgds&lt;BR /&gt;Alexander M. Ermes</description>
      <pubDate>Wed, 06 Dec 2000 14:11:19 GMT</pubDate>
      <guid>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471016#M775336</guid>
      <dc:creator>Alexander M. Ermes</dc:creator>
      <dc:date>2000-12-06T14:11:19Z</dc:date>
    </item>
    <item>
      <title>Re: problem with max extents oracle</title>
      <link>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471017#M775337</link>
      <description>As of Oracle 7.3, you can define unlimited extents :&lt;BR /&gt;alter index ... storage (maxextents unlimited);&lt;BR /&gt;&lt;BR /&gt;This will fix your problem. Then you can have a deeper look to set more adequate next extent size.&lt;BR /&gt;&lt;BR /&gt;However, the name of segment you mention looks like a rollback segment. If it is right consider dropping it and recreate it.&lt;BR /&gt;&lt;BR /&gt;Regards</description>
      <pubDate>Wed, 06 Dec 2000 14:13:09 GMT</pubDate>
      <guid>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471017#M775337</guid>
      <dc:creator>Bruno DESQUESNE</dc:creator>
      <dc:date>2000-12-06T14:13:09Z</dc:date>
    </item>
    <item>
      <title>Re: problem with max extents oracle</title>
      <link>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471018#M775338</link>
      <description>Hi Mauro.&lt;BR /&gt;Bruno is right, you can go for unlimited extents, but that could give some unwanted results later. If you limit the extents,&lt;BR /&gt;you can keep it under control.&lt;BR /&gt;rgds&lt;BR /&gt;Alexander M. Ermes</description>
      <pubDate>Wed, 06 Dec 2000 14:25:18 GMT</pubDate>
      <guid>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471018#M775338</guid>
      <dc:creator>Alexander M. Ermes</dc:creator>
      <dc:date>2000-12-06T14:25:18Z</dc:date>
    </item>
    <item>
      <title>Re: problem with max extents oracle</title>
      <link>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471019#M775339</link>
      <description>I try to solve but this message appear :&lt;BR /&gt;ORA-00406: COMPATIBLE parameter needs to be 7.3.0.0.0 or greater&lt;BR /&gt; &lt;BR /&gt; but the version is 7.3.2.3, I no understand !!!&lt;BR /&gt; &lt;BR /&gt;      Thanks for your time&lt;BR /&gt;                          Mauro</description>
      <pubDate>Wed, 06 Dec 2000 14:31:48 GMT</pubDate>
      <guid>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471019#M775339</guid>
      <dc:creator>Mauro Zabalet</dc:creator>
      <dc:date>2000-12-06T14:31:48Z</dc:date>
    </item>
    <item>
      <title>Re: problem with max extents oracle</title>
      <link>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471020#M775340</link>
      <description>Mauro, &lt;BR /&gt;go to the init.ora file.&lt;BR /&gt;You will find the compatible parameter in there. Set it to the requested value.&lt;BR /&gt;Rgds&lt;BR /&gt;Alexander M. Ermes&lt;BR /&gt;</description>
      <pubDate>Wed, 06 Dec 2000 14:49:22 GMT</pubDate>
      <guid>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471020#M775340</guid>
      <dc:creator>Alexander M. Ermes</dc:creator>
      <dc:date>2000-12-06T14:49:22Z</dc:date>
    </item>
    <item>
      <title>Re: problem with max extents oracle</title>
      <link>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471021#M775341</link>
      <description>Dears &lt;BR /&gt;&lt;BR /&gt;     I found it the parameters &lt;BR /&gt;     compatible = 7.3.0.0&lt;BR /&gt; And I can Fix the problem.&lt;BR /&gt;       Thanks for all.&lt;BR /&gt;                      Mauro&lt;BR /&gt; &lt;BR /&gt;</description>
      <pubDate>Wed, 06 Dec 2000 15:36:19 GMT</pubDate>
      <guid>https://community.hpe.com/t5/operating-system-hp-ux/problem-with-max-extents-oracle/m-p/2471021#M775341</guid>
      <dc:creator>Mauro Zabalet</dc:creator>
      <dc:date>2000-12-06T15:36:19Z</dc:date>
    </item>
  </channel>
</rss>

