Re: ora-0604 error occurred at recursive SQL level string

From: Jim Lyons <jlyons_at_weblyons.com>
Date: 25 Oct 2001 08:22:40 -0700
Message-ID: <e67857c9.0110250722.11c606cd@posting.google.com>

Raphael Duenas <raf_at_srd.fr> wrote in message news:<3BD674E1.A374AE1D_at_srd.fr>...
> Hi,
>
> in a ProC program i've 11 tables to drop and in any orders i dropped
> these, only five tables are effectively dropped before the message error
> ora-0604 appear for the six others. Does it exist a limit for recursive
> drop ?

How much trouble shooting have you done? Have you tried to drop them in sqlplus? 604 indicates, I believe, some sort of space problem. You may need to allocate more space or commit after each drop.

Jim Lyons
UT Austin Received on Thu Oct 25 2001 - 10:22:40 CDT