OraFAQ Forum: Server Utilities » EXP-00003: no storage definition found for segment(25, 19)

Home » RDBMS Server » Server Utilities » EXP-00003: no storage definition found for segment(25, 19)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXP-00003: no storage definition found for segment(25, 19) [message #245862]

Tue, 19 June 2007 01:50

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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

vasudev_boppa2001
Messages: 11
Registered: May 2007

Junior Member

i didn't get the data for that query. what will be the solution

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

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".

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

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 ^^^^^^^^

Report message to a moderator

Previous Topic:	impdp REAMP_DATAFILE arghhhh
Next Topic:	SQL Loader + position

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 10:42:38 CDT 2024