Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: EXP-00008

Re: EXP-00008

From: Suzy Vordos <lvordos_at_uswest.com>
Date: Mon, 31 Jul 2000 00:34:49 -0600
Message-Id: <10574.113337@fatcity.com>


Try this (as connect internal, startup restrict): catalog.sql, catproc.sql, catrep.sql. You won't need to run catexp.sql because it's called by catalog.sql.

Just tried this myself on 7.3.4, and a full export ran without error.

Suzy

Cyril Thankappan wrote:
>
> Hello!
>
> Thanks suzy..
>
> I don't know how the catrep.sql was run the 1st time.
>
> But since I had the opportunity to apply the patch.
>
> The sequence was..
>
> from my side, I have done the following.
>
> a. Executed catalog.sql
> b. catproc.sql
> c. catrep.sql
> d. catexp.sql
>
> When the above didn't work
> I ran catnorep.sql and catrepr.sql (in that order!)
>
> and still when it didn't work
>
> I ran catalog.sql catproc.sql catexp.sql
> (didn't run catrep.sql)
>
> and still it doesn't work..
>
> Thanx for your reply..
> thanx for looking into it.
> can u pls give me some lead into it
>
> ------Original Message------
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: July 30, 2000 11:54:08 PM GMT
>
> 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
> > 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
Received on Mon Jul 31 2000 - 01:34:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US