-
When I try to make a full export on a database of Oracle 8.1.7.3.0 on AIX 5.0, I get this error message and the export terminated unsuccessfully.
EXP-00003: no storage definition found for segment (3,2)
What's wrong with the database?
Is there a way to check where is the bad segment?
Thanks.
Queyon
Queyon Zeng
-
1. If you are using older versions of EXPORT utility with newer versions of database, then EXP-3 is commom. Since the older version of EXP cannot understand the new features included in the new database.
for eg,
When an Oracle8 database, with partitioned indexes, is exported with
an Oracle7 export-utility you encounter an EXP-3 on exporting
objects because they are not featured by an Oracle7 RDBMS.
2. Maybe the export data dictionary views was not properly created
run
catalog.sql
catproc.sql
catexp.sql
3. Check if the USER exporting has appropriate privileges, say, EXP_FULL_DATABASE , etc
Got this info from metalink..
KN
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|