Re: Oracle 7.3.4 exp problem

Hi,

After I drop ROLE exp_full_database and ROLE imp_full_database. I rerun the CATEXP file and then restart the database. But everything seems the same. Did I miss anything ? Regards,

Lawrence Lu

Graham Thornton wrote:

> Hi
>
> Try rerunning the CATEXP file and see if that helps
>
> HTH
>
> Graham
>
> llr wrote:
>
> > Hi,
> >
> > I had a working Oracle 7.3.4 installation on SunOS 5.5.1
> > ,SPARCstation-5.
> > And I tried to migrate the database from this workstation to the other.
> > After I executed the exp command, some problems happened as the
> > following :
> >
> > svr:/users/data> exp data/data file=data.dmp compress=y indexes=y
> > log=data.log
> >
> > Export: Release 7.3.4.0.1 - Production on Tue Oct 3 18:06:51 2000
> > Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
> > Connected to: Oracle7 Server Release 7.3.4.0.1 - Production
> > PL/SQL Release 2.3.4.0.0 - Production
> > Export done in ZHT16BIG5 character set
> >
> > About to export specified users ...
> > About to export VISIT's objects ...
> > . exporting snapshots
> > . exporting snapshot logs
> > . exporting job queues
> > . exporting refresh groups and children
> > . exporting database links
> > . exporting sequence numbers
> > . exporting cluster definitions
> > . about to export VISIT's tables via Conventional Path ..
> > . . exporting table AREA
> > EXP-00008: ORACLE error 6550 encountered
> > ORA-06550: line 1, column 25:
> > PLS-00302: component 'DBMS_EXPORT_EXTENSION' must be declared
> > ORA-06550: line 1, column 8:
> > PL/SQL: Statement ignored
> > . . exporting table AUDITING
> > EXP-00008: ORACLE error 1008 encountered
> > ORA-01008: not all variables bound
> > . . exporting table BARCODE
> > EXP-00008: ORACLE error 1008 encountered
> > ORA-01008: not all variables bound
> > ... ... ...
> > . . exporting table BRIEF
> > EXP-00008: ORACLE error 1008 encountered
> > ORA-01008: not all variables bound
> > . . exporting table WCHEDULE
> > EXP-00008: ORACLE error 1008 encountered
> > ORA-01008: not all variables bound
> > . exporting synonyms
> > . exporting views
> > . exporting stored procedures
> > . exporting referential integrity constraints
> > . exporting triggers
> > . exporting posttables actions
> > Export terminated successfully with warnings.
> >
> > Any ideas?
> >
> > Regards,
> >
> > Lawrence Lu
Received on Wed Oct 04 2000 - 05:04:38 CDT