It looks like the problem is in your roll back segment 3.
Run the following querry and confirm it
Check all the storage definitions.Code:select * from dba_rollback_segs;
Does it look like the rest?Code:Select * from dba_rollback_segs where segment_id = 3;
If different look at the segment_name. Try taking that segment off-line.
It must be OFFLINE.Code:alter rollback segment segment_name offline; select status from dba_rollback_segs where segment_name = 'SEGMENT_NAME';
Then drop that rollback segment. Re-try your FULL export. If the ROLLBACK segment will not go offline, then export using USERS.
Sam




Reply With Quote