Home » RDBMS Server » Backup & Recovery » While Taking Exp in 9.2.0.6
While Taking Exp in 9.2.0.6 [message #148597] Fri, 25 November 2005 04:29 Go to next message
kumar_dln
Messages: 5
Registered: October 2005
Location: Philadelphia
Junior Member

Hi All,

When I was taking Exp for an user, Getting the follwing Ora Error.

Execute like this :

exp FILE = D:\OraDumps\NBSM\ExpNBSMD_25112005.dmp log = D:\O
raDumps\NBSM\ExpNBSMD_25112005.log

. . exporting table TRN_PRECOOK
EXP-00003: no storage definition found for segment(9, 36627)

There is a CLOB Object in the above Table.

Could you pls tell me why this error is coming?

Thanks & Rgds,
DLN Kumar.
Re: While Taking Exp in 9.2.0.6 [message #148649 is a reply to message #148597] Fri, 25 November 2005 14:53 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

as per oracle documentation....

EXP-00003: no storage definition found for segment (name, num)
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.

thats it...

Regards
Sunilkumar
Previous Topic: getting the bad blocks
Next Topic: how to recover database if o/s corrupted & also loss server?plz step by step with script with de
Goto Forum:
  


Current Time: Wed Dec 04 03:19:12 CST 2024