Re: Truncate on Oracle 7.2

In article <01bcbf5a$867c82c0$310006c0_at_pharma10>,   "Andrea Savino" <A.Savino_at_agora.stm.it> wrote:
>
> Hi, sorry for my bad english.
>
> I have a problem with a Truncate Table on Oracle 7.2 running on Netware.
> If my table have no index the Truncate Table have no problem, if I create
> just one index (no change changing column indexed) and I try to execute a
> Truncate Table Oracle give me a Internal error.
>
> I'm waiting for Oracle Helpdesk but if someone knows if this is a bug or if
> thyere is a work around ..
> A.Savino_at_agora.stm.it

We also face the same Problem and workaround of this problem was given to us by oracle india is to drop ths indexes of the table . truncate it and recreate the indexes.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet