Is it possible you ran catproc.sql after catrep.sql? I was able to
duplicate this problem doing just that... the replication packages were
rendered invalid. Fixed easily by running catproc.sql, then catrep.sql,
then a full export ran without error.
Cyril Thankappan wrote:
>
> Hi!
> Suzy , following is the error listing
>
> exportingreferential integrity constraints
> . exporting posttables actions
> EXP-00008:ORACLE error 6550 encountered
> ORA-06550: line 1, column 18:
> PLS-00201:identifier 'SYS.DBMS_REPCAT_MAS' must be declared
> ORA-06550: line 1, column7:
> PL/SQL: Statement ignored
> ORA-06512: at "SYS.DBMS_SYS_SQL", line348
> ORA-06512: at "SYS.DBMS_SQL", line 141
> ORA-06512: at"SYS.DBMS_EXPORT_EXTENSION", line 64
> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION",line 115
> ORA-06512: at line 1
> EXP-00000: Export terminated unsuccessfully
> ------Original Message------
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: July 30, 2000 1:44:23 AM GMT
>
> What is the ORA- error that follows EXP-00008 ??
>
> Cyril Thankappan wrote:
> >
> > Hello!
> >
> > I need some help with EXP-00008 error.
> >
> > I have tried all of the following options
> >
> > a. Increasing shared_pool_size
> > b. Increasing system tablespace size
> > c. Running the combination
> > of catalog,catproc,catrep,catexp
> > (spent a night doing it!!!!)
> >
> > But to no avail... can someone out there helpme!
> >
> > This is on Oracle 7.3.4
> >
> > I have found in Metalink some one saying that
> > on following approach mentioned in point c
> > his problem was solved, however, in my case
> > the problem still persists.
> >
> > This problem only persists in databases
> > where the catrep had been 'ever' run.
> >
> > Kindly help me as we are planning to use
> > replication, and are not able to do so,
> > because of this.
> >
> > Thanks
> >
> > ______________________________________________
> > FREE Personalized Email at Mail.com
> > Sign up at http://www.mail.com/?sr=signup
> >
> > --
> > Author: Cyril Thankappan
> > INET: cyril_thank_at_india.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Author: Suzy Vordos
> INET: lvordos_at_uswest.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> ______________________________________________
> FREE Personalized Email at Mail.com
> Sign up at http://www.mail.com/?sr=signup
>
> --
> Author: Cyril Thankappan
> INET: cyril_thank_at_india.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Sun Jul 30 2000 - 17:32:30 CDT
