Re: EXP-00222 Error

From: Dennis R. Otero <dennis.otero-1_at_edams.ksc.nasa.gov>
Date: 1996/09/15
Message-ID: <323BFF3A.665A_at_edams.ksc.nasa.gov>#1/1


Robin Aylesworth wrote:
>
> Oracle told you they can't help you with their own error message?
> I would go back to them and tell them that is a totally unacceptable
> answer. Ask them to escalate your problem to the escalation
> manager. I've looked up these errors and cannot find anything
> helpful either. This is their software, they should be able to
> help you solve the problem...isn't that why we pay maintenance
> fees?
>
> Sorry I couldn't be of more help, but go back to Oracle and
> don't take "no" for an answer!
>
> Robin Aylesworth
>
> sarnold_at_usit.net wrote in article > > Our office is currently running Oracle 7.0.16.4 on an HP 9000. During
> > a full export we sometimes get the following Oracle and Export errors:
> >
> > EXP-00008: ORACLE error 1403 encountered
> > ORA-01403: no data found
> > EXP-00222:
> > System error message
> > EXP-00000: Export terminated unsuccessfully
> >
> > In the Oracle error message documentation there is no explanation for
> > the EXP-00222 error. We have called Oracle support and they could not
> > help us. Has anyone encountered this error and if so do they know
> > what is happening?
> >
> > Please e-mail any possible explanation or solutions to
> > sarnold_at_usit.net. Thanks.
> >
> > Sandra Arnold
> > Philips Consumer Electronics
> >
Sandra
I ran oerr ora 222 on my system and got: 00222, 00000, "control file may not be queried using dispatcher"

// *Cause:  Attempted to use client process connected to dispatcher. This is
//          not allowed for queries to control file fixed tables due to the
//          memory requirements.
// *Action: Connect directly to the instance then execute query.
Hope this helps
Dennis
DBA _at_ United Space Alliance Received on Sun Sep 15 1996 - 00:00:00 CEST

Original text of this message