EXP-00003: No storage definition found for segment (2,2) oracle 8i


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(2, 2)
EXP-00000: Export terminated unsuccessfully





SELECT SEGMENT_NAME,TABLESPACE_NAME,STATUS,FILE_ID FROM DBA_ROLLBACK_SEGS

SEGMENT_NAME                   TABLESPACE_NAME                STATUS              FILE_ID
------------------------------ ------------------------------ ---------------- ----------
SYSTEM                         SYSTEM                         ONLINE                    1
RBS0                           RBS                            ONLINE                    2
RBS1                           RBS                            ONLINE                    2
RBS2                           RBS                            ONLINE                    2
RBS3                           RBS                            ONLINE                    2
RBS4                           RBS                            ONLINE                    2
RBS5                           RBS                            ONLINE                    2
RBS6                           RBS                            ONLINE                    2
RBS7                           RBS                            ONLINE                    2
RBS8                           RBS                            ONLINE                    2
RBS9                           RBS                            ONLINE                    2
RBS10                          RBS                            ONLINE                    2
ARSYSTEMROLL_TROUBLETICKET     ARSYSTEM                       ONLINE                    7
 


execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('RBS');


PL/SQL procedure successfully completed.


 

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post