Эти материалы помечены как "окончательные". Показать Ответов: 2
Can you copy the data with a database link?
create table fu as select * from fu@remotedb
insert into fu select * from fu@remotedb
If you have metalink access then you should read this note 274076.1
I am pasting the contents here anyways. Hopefully it will solve your problem.
The EXP-3 error only occurs when the export from the 126.96.36.199.0 or any higher release database (e.g. 188.8.131.52.0 or 10.1.0.4.0) is done with a lower release export utility, e.g. 184.108.40.206.0. The reason to run an export from a 220.127.116.11.0
or any higher release database (e.g. 18.104.22.168.0 or 10.1.0.4.0) with a 22.214.171.124.0 export utility, is to import the export dump file later into a target database of that lower release.
Note: if your intention is to export from a 126.96.36.199.0 database in order to import (back) into a 188.8.131.52.0 target database, there is no need to use a pre-184.108.40.206 release export utility. In that situation use the 220.127.116.11.0 export utility.
Rerun the export and specify the parameter COMPRESS=Y (this is the default value for COMPRESS).
If you have a table with a secondary object, e.g. a LOB column, then this workaround might not work and you will re-produce the EXP-3 error during export. In that case, use workaround 2.
a. Make a note of the export definition of exu9tne from $ORACLE_HOME/rdbms/admin/catexp.sql
b. Copy this to a new file and add:
"UNION ALL select * from sys.exu9tneb"
to the end of the definition
e.g. In the 18.104.22.168.0 or any higher release source database (e.g. 22.214.171.124.0 or 10.1.0.4.0), the workaround view would be:
CREATE OR REPLACE VIEW exu9tne (
tsno, fileno, blockno, length) AS
SELECT ts#, segfile#, segblock#, length
WHERE ext# = 1
SELECT * from sys.exu9tneb
c. Run this as the SYS user (!) against the database that needs to be exported.
d. Re-run the export as required.
e. Put back the original definition of exu9tne as obtained in step a.
Note: only use this workaround when absolutely necessary, and don't forget to put back the original definition of the view SYS.exu9tne as mentioned in step e.
Hope it helps.