Home » RDBMS Server » Server Utilities » exp-00003 no storage definition found for the segment (7, 255)
icon5.gif  exp-00003 no storage definition found for the segment (7, 255) [message #111292] Tue, 15 March 2005 06:23 Go to next message
vedagopal2004
Messages: 2
Registered: March 2005
Location: Hyderabad
Junior Member

Dear All,

I am trying to export a Database in 10g from a client machine having 9i client software and exp.exe utility.

I am getting the error
exp-00003 no storage definition found for the segment (7,255)

Information: The Billing_Record contains a Column with Datatype CLOB. All the other tables are exporting without fail.

Thank & Regards

[Updated on: Tue, 15 March 2005 06:31]

Report message to a moderator

Re: exp-00003 no storage definition found for the segment (7, 255) [message #111308 is a reply to message #111292] Tue, 15 March 2005 09:27 Go to previous messageGo to next message
jbatista
Messages: 8
Registered: March 2005
Location: Horsham, PA
Junior Member
The EXP-3 error occurs when the export is done with a lower release export utility.

Re: exp-00003 no storage definition found for the segment (7, 255) [message #111388 is a reply to message #111308] Tue, 15 March 2005 23:42 Go to previous messageGo to next message
vedagopal2004
Messages: 2
Registered: March 2005
Location: Hyderabad
Junior Member

Thank you for the information provided.

But I need to fix this problem because I am writing a script which executes on Client Machine having 9i Client Software.

Thanks and Regards

[Updated on: Tue, 15 March 2005 23:43]

Report message to a moderator

Re: exp-00003 no storage definition found for the segment (7, 255) [message #111444 is a reply to message #111292] Wed, 16 March 2005 07:56 Go to previous messageGo to next message
jbatista
Messages: 8
Registered: March 2005
Location: Horsham, PA
Junior Member
What's the version of:
your client machine 9.x.x.x.x
Export Release 9.x.x.x.x
database 10.1.0.x.x

Re: exp-00003 no storage definition found for the segment (7, 255) [message #111472 is a reply to message #111292] Wed, 16 March 2005 11:08 Go to previous messageGo to next message
jbatista
Messages: 8
Registered: March 2005
Location: Horsham, PA
Junior Member
Rerun the export and specify the parameter COMPRESS=Y (this is the default value for COMPRESS).

If you have a table with a secondary object, e.g. a LOB column, then this workaround might
not work and you will re-produce the EXP-3 error during export.

Re: exp-00003 no storage definition found for the segment (7, 255) [message #115868 is a reply to message #111292] Thu, 14 April 2005 14:25 Go to previous messageGo to next message
lunat1k
Messages: 1
Registered: April 2005
Location: CA
Junior Member
I've noticed this 9i->9i on localy managed tablespaces for tables where there is a clob. It happens on empty and non-empty tables. There is some other factor as well but I haven't put my finger on it yet.

[Updated on: Thu, 14 April 2005 14:33]

Report message to a moderator

Re: exp-00003 no storage definition found for the segment (7, 255) [message #160300 is a reply to message #115868] Fri, 24 February 2006 05:40 Go to previous messageGo to next message
raj_alapati
Messages: 2
Registered: February 2006
Location: Hyderabad
Junior Member

Hi,

Hi

Do any body have idea regarding missing data or missing constraints after export and import which is done with warnings
Recently i exported one of my schema to another schema which is newly created. While exporting i saw an error Exp-00003 No storage definition found for segment (Some Number,Some number) , i thought that beacuse of clob datatype in the table for which it showed warning and we ignored it . after some days we noticed the constraint primary key missing on the table which the source schema use to have
Do any body have idea why the warning is coming and why it is missing every time i export?
what is the alternative i can go through and take care from now onwards , pls help me ,it is going to be serious issue now.

Even i tried this

exp system/sbsystem@orcl.smart-bridge.com file=\\jupiter\TONIK\DailyBackups\tonikco_dev_feb24_1.dmp owner=tonikco_dev COMPRESS=Y

It did not work, so i used dbexp where i used only exp upto yesterday , Now i want to use Dbexp for advanced features
But my Dos is giving me error unknown command
"
'dbexp' is not recognized as an internal or external command,
operable program or batch file.

Pls help me in solving one by one , Embarassed
"
Thank you
Raj Deep.A
Re: exp-00003 no storage definition found for the segment (7, 255) [message #160319 is a reply to message #160300] Fri, 24 February 2006 07:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Insufficient information.
Always post Exact error message ( Please do NOT explain the error message.Especially like this "Some Number,Some number" .Makes no sense to us). Post the exact errors,oracle version, OS version etc, and what you did ( commands)
Seems there are different versions of oracle involved.
Never export with COMPRESS=y and there is nothing called as dbexp ( may be, expdp in 10g).

[Updated on: Fri, 24 February 2006 07:38]

Report message to a moderator

Re: exp-00003 no storage definition found for the segment (7, 255) [message #160325 is a reply to message #160319] Fri, 24 February 2006 07:58 Go to previous messageGo to next message
raj_alapati
Messages: 2
Registered: February 2006
Location: Hyderabad
Junior Member

Oh .. Sorry , i mean expdb only , but it is issuing the same error

'expdb' is not recognized as an
operable program or batch file.

what i need to do , if my export utility has to be updated .

the (NO,No) is EXP-00003: no storage definition found for segment(8, 11369)


Even though the data is missing , its ok , but i need to know the reason why the constraint is missing (Primary key ) for that particular table which is showing the warning , and i need to rectify that

Thank you
Raj Deep.A

Re: exp-00003 no storage definition found for the segment (7, 255) [message #160329 is a reply to message #160325] Fri, 24 February 2006 08:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Again, missing information.
No information on version involved.
Seems Source and target databases are of DIFFERENT versions.
>>Oh .. Sorry , i mean expdb only

Itis expdp. Not expdb
>>but i need to know the reason why the constraint is missing (Primary key ) for that particular table which is showing the warning , and i need to rectify that

Post the relevant portion of the log.
Maybe, you did have a constraint violation during import.

Re: exp-00003 no storage definition found for the segment (7, 255) [message #321209 is a reply to message #160329] Mon, 19 May 2008 07:39 Go to previous message
Haler
Messages: 71
Registered: October 2004
Member
Hello,
I have the same problem with clob.
Export does not 10.2.0.1 with clob.
you have to patch in 10.2.0.3 and that's OK.
Previous Topic: export / import timing difference
Next Topic: Reg IMP-00009: abnormal end of export file
Goto Forum:
  


Current Time: Fri Dec 09 06:16:03 CST 2016

Total time taken to generate the page: 0.13600 seconds