exp system/manager inctype=INCREMENTAL file=i01.dmp

Export: Release 8.1.7.3.0 - Production on Fri Nov 21 10:01:42 2003

© Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
With the Partitioning option
JServer Release 8.1.7.3.0 - Production
Export done in ZHS16CGB231280 character set and ZHS16CGB231280 NCHAR character s
et

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
EXP-00003: no storage definition found for segment(6, 2)
EXP-00000: Export terminated unsuccessfully
这是什么意识？？？？？

EXP-00003 no storage definition found for segment(number, number)
Cause: Export could not find the storage definitions for a cluster, index, or table.

Action: Record the accompanying messages and report this as an Export internal error to Oracle Customer Support

metalink:

· fact: Oracle Server - Enterprise Edition 8.1.6
·
· fact: AIX-Based Systems
·
· fact: EXP
·
· symptom: EXP-00003: no storage definition found for segment(%lu, %lu)
·
· cause: This is <bug:1080833>.
·
· Two oracle users A and B exist.
· A owns a table T1 and has an index I1.
· B creates an index I2 on T1.
· When we export T1 as A , this fails with EXP-00003
· no storage definition found for segment(%lu, %lu)
· The file and the block specified belong to the I2 index created by B.
·
·


fix:

Fixed in 8.1.6.2 and 8.1.7
Workaround is to use system/manager for the export

说明若你的oracle server 是 8173,这个bug应该OK了的。

还有可能：
你创建了TEMPORARY tables 和相关索引。这时会可能报错。

你的问题解决如下：
Export is failing when a tablespace containing rollback segments was converted
from dictionary to locally managed.


Solutions Description
---------------------

*** ****************************************************
*** Solution 1 Migrate the tablespace back to dictionary
*** ****************************************************

SQL> execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('TRY_RBS');
PL/SQL procedure successfully completed.

$ exp system/manager full=Y

Export: Release 8.1.6.1.0 - Production on Mon Nov 13 10:57:33 2000
&copy; Copyright 1999 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 105.6.246.14.0
Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
...


*** **************************************************
*** Solution 2 Drop and recreate the rollback segments
*** **************************************************

SQL> drop rollback segment TRY_RS01;
Rollback segment dropped.

SQL> drop rollback segment TRY_RS02;
Rollback segment dropped.

SQL> create rollback segment try_rs01 tablespace TRY_RBS
2 storage (minextents 5);
Rollback segment created.

SQL> create rollback segment try_rs02 tablespace TRY_RBS
2 storage (minextents 3);
Rollback segment created.

SQL> alter rollback segment TRY_RS01 online;
Rollback segment altered.

SQL> alter rollback segment TRY_RS02 online;
Rollback segment altered.

$ exp system/manager full=y

Export: Release 8.1.6.2.0 - Production on Mon Nov 13 13:29:01 2000
&copy; Copyright 1999 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
...