| Error While Taking Export [message #251452] |
Fri, 13 July 2007 11:42  |
faiz_hyd
Messages: 294
Registered: February 2006
|
Senior Member |
|
|
Hi,
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.
Thanks
|
|
|
|
| Re: Error While Taking Export [message #251453 is a reply to message #251452] |
Fri, 13 July 2007 11:48  |
DreamzZ
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;
| Quote: | 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.
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
