EXP数据时出现exp-00003错误,具体如下
C:\>exp its/oracle@orcl tables=barcde compress=n trigger=y files=barcode.dmp log=exp.log
Export: Release 8.1.7.4.1 - Production on Fri Jan 4 11:15:52 2008
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set
server uses ZHT16BIG5 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table BARCODE
EXP-00003: no storage definition found for segment(151, 45497)
Export terminated successfully with warnings.
在网上找找,说是因为用低版本导高版本数据库数据造成的,将compress=y就可以解决,试了compress=y后,顺利导出。感谢那位不知名朋友。