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

    Angry

    When I try to make a full export on a database of Oracle 8.1.7.3.0 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?
    Thanks.

    Queyon
    Queyon Zeng

  2. #2
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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

    run
    catalog.sql
    catproc.sql
    catexp.sql

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

    Got this info from metalink..


    KN

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