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

Home -> Community -> Usenet -> c.d.o.server -> Oracle 7.3.4 exp problem

Oracle 7.3.4 exp problem

From: llr <llr_at_iii.org.tw>
Date: 3 Oct 2000 10:55:38 GMT
Message-ID: <39D9BE19.704B7DE2@iii.org.tw>

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 - 05:55:38 CDT

Original text of this message

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