Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXP-0003 No storage definition found for segment (0,0) error while using EXP for export

mradul goyalSep 30 2015 — edited Oct 1 2015

Hi,

I am trying to export a schema using EXP command on the server which is throwing me error EXP-0003 No storage definition found for segment (0,0).

exp userid=user/pass@SID file=vmper01cm_30Sep2015.dmp log=vmper01cm_30Sep2015.log statistics=NONE

The export release it shows me is -- Export Release 11.2.0.1.0 - Production on Wed Sep 30 02:38::31 2015

and Database is

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

I am not sure if it is because of the varying version of export release and database release or there is another cause for it.

The error are also showing for tables where are no rows (empty tables).

I have later perform an export on our 10g machine where the export release and database release are same and it says export terminated with no warnings.

This is for 10g database

Export: Release 10.2.0.4.0 - Production on Mon Sep 28 12:01:09 2015

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production