EXP-00003: no storage definition found for segment (3,2)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: EXP-00003: no storage definition found for segment (3,2)

  1. #1


    When I try to make a full export on a database of Oracle on AIX 5.0, I get this error message and the export terminated unsuccessfully.

    EXP-00003: no storage definition found for segment (3,2)

    What's wrong with the database?
    Is there a way to check where is the bad segment?

    Queyon Zeng

  2. #2
    Join Date
    Feb 2000
    NJ, United States
    1. If you are using older versions of EXPORT utility with newer versions of database, then EXP-3 is commom. Since the older version of EXP cannot understand the new features included in the new database.

    for eg,

    When an Oracle8 database, with partitioned indexes, is exported with
    an Oracle7 export-utility you encounter an EXP-3 on exporting
    objects because they are not featured by an Oracle7 RDBMS.

    2. Maybe the export data dictionary views was not properly created


    3. Check if the USER exporting has appropriate privileges, say, EXP_FULL_DATABASE , etc

    Got this info from metalink..


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width