EXP-00003: No Storage Definition Found For Segment(6,2)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: EXP-00003: No Storage Definition Found For Segment(6,2)

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    EXP-00003: No Storage Definition Found For Segment(6,2)

    EXP-00003: No Storage Definition Found For Segment(6,2)

    I'm getting this error message when I try to due a Full Export.....

    my parfile is looks like this:

    full=y
    file=test.dmp
    log=test.log
    direct=y
    consistent=y
    buffer=50000
    feedback=5000

    I'm exporting as a user sys.

    What's wrong with this?

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    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 Support Services.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    and what table or index is giving this error?

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    1) which version are u using ?
    2) did u move ur tablepsce from dictionary managed to locally managed ?
    3) are u using different exp version ( may be after applying patches etc.. ) ?
    4) try disabling the indexes take and enable them after taking full export ( if ur business permits ) ?

    possibly u could be hitting a bug .
    siva prakash
    DBA

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