Home » RDBMS Server » Server Utilities » Error While Taking Export
Error While Taking Export [message #251452] Fri, 13 July 2007 11:42 Go to next message
Messages: 294
Registered: February 2006
Senior Member

I am trying to export a Schema User ,
logged on SYS user on cmd Prompt and i issued normal Exp options with Compress=no, and for Partitioned tables while exporting
it gave this error and no rows exportted
EXP-00003: no storage definition found for segment(19, 7899)

Oracle is 9i Rel 2,
Any idea why this happens with partitioned tables.

Re: Error While Taking Export [message #251453 is a reply to message #251452] Fri, 13 July 2007 11:48 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Check it
select SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME from dba_segments where HEADER_FILE = 19 and HEADER_BLOCK = 7899; 

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 customer support.
Previous Topic: Using sql loader of 9i client to load data on Oracle 10g.
Next Topic: Oracle 10g error ORA-24335 on data import
Goto Forum:

Current Time: Mon Jul 24 21:41:47 CDT 2017

Total time taken to generate the page: 0.12669 seconds