Skip to content
October 17, 2012 / doganay

EXP-00003: no storage definition found for segment(0, 0)


Problem:

$ exp myuser/mypass@mydb
EXP-00003: no storage definition found for segment(0, 0)


Solution:

1) run this sql, if something not like 0 returns move those indexes, if 0 returns go to step 2

select count(*) from dba_indexes where owner<>table_owner;

2) Rerun the export and specify the parameter COMPRESS=Y (this is the default value for COMPRESS).

if the error still occurs,

3) Copy $ORACLE_HOME/rdbms/admin/catexp.sql to $ORACLE_HOME/rdbms/admin/catexp2.sql

add this line to $ORACLE_HOME/rdbms/admin/catexp2.sql:

"UNION ALL select * from sys.exu9tneb"

run

$ORACLE_HOME/rdbms/admin/catexp2.sql

if the error still occurs,

4) Upgrade your client version. Your version must be equal or higher than exp version of your target db.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: