Home » RDBMS Server » Server Utilities » EXP-00003: no storage definition found for segment(25, 19)
EXP-00003: no storage definition found for segment(25, 19) [message #245862] Tue, 19 June 2007 01:50 Go to next message
vasudev_boppa2001
Messages: 11
Registered: May 2007
Junior Member
Hi All,

When iam trying to export i got this msg "EXP-00003: no storage definition found for segment(25, 19)", Did you face this problem? what is the solution?

Thanks
Re: EXP-00003: no storage definition found for segment(25, 19) [message #245881 is a reply to message #245862] Tue, 19 June 2007 02:53 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
see if Your datafile with file_id 25 are exists and are online. Try to make
select * from your_table.
Name of your_table You can find from the select

select name
from sys.obj$
where obj# in(
select obj#
from sys.tab$
where file#=25
and block#=19
)

this select are correct in the case if your table are not IOT and not partitioned.
Re: EXP-00003: no storage definition found for segment(25, 19) [message #245889 is a reply to message #245862] Tue, 19 June 2007 03:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
exp-00003: no storage definition found for segment(%lu, %lu)
 *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.

Post the Oracle version (4 decimals).
Post the "accompanying messages".

Regards
Michel
Re: EXP-00003: no storage definition found for segment(25, 19) [message #245927 is a reply to message #245881] Tue, 19 June 2007 05:55 Go to previous messageGo to next message
vasudev_boppa2001
Messages: 11
Registered: May 2007
Junior Member
i didn't get the data for that query. what will be the solution
Re: EXP-00003: no storage definition found for segment(25, 19) [message #245930 is a reply to message #245927] Tue, 19 June 2007 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the Oracle version (4 decimals).
Post the "accompanying messages".


select owner, segment_name, partition_name, segment_type
from dba_extents
where file_id = 25
  and 19 between block_id and block_id+blocks-1
/

Regards
Michel
Re: EXP-00003: no storage definition found for segment(25, 19) [message #245933 is a reply to message #245930] Tue, 19 June 2007 06:19 Go to previous messageGo to next message
vasudev_boppa2001
Messages: 11
Registered: May 2007
Junior Member
it's displayed
owner as user1,
Segment_name as "SYS_LOB0000045986C00002$$",
Partition Name is Null
and segment_Type is "LOBSEGMENT".

Re: EXP-00003: no storage definition found for segment(25, 19) [message #245963 is a reply to message #245933] Tue, 19 June 2007 07:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Third time:

Post the Oracle version (4 decimals).
Post the "accompanying messages".


Regards
Michel

Re: EXP-00003: no storage definition found for segment(25, 19) [message #246015 is a reply to message #245963] Tue, 19 June 2007 10:20 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jun 19 15:19:31 2007

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.



vasudev_boppa2001......Micheal asking you this ^^^^^^^^
Previous Topic: impdp REAMP_DATAFILE arghhhh
Next Topic: SQL Loader + position
Goto Forum:
  


Current Time: Sun Dec 04 02:17:58 CST 2016

Total time taken to generate the page: 0.20352 seconds