Re: Oracle 7.3.4 exp problem

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 Tue Oct 03 2000 - 08:33:00 CDT