Re: [GUSDEV] GUS dba scripts

[Bryan C. <di...@pc...>]

On Wed, Nov 08, 2006 at 07:44:48PM +0000, marc jackson wrote:
> Does anyone know why the dbadumpschema perl script returns an oracle error:
> 
> ORA-00604

        well, you didn't include it here, but from your previous
        mail I found:

Exception in thread "main" java.lang.RuntimeException:
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

        it may just be that you need to increase the number of open
        cursors allowed.  I suggest this because I vaguely recall
        having a similar issue on a fresh gus/oracle install several
        years ago.

        Cheers,
        Bryan Cardillo
        Penn Bioinformatics Core
        University of Pennsylvania