Hi there,
I have some problems to export any table, so it seems, of my Oracle 7.3.4
database. I run into the following error:
EXP-00003: no storage definition found for segment (name, num)
Cause: Export could not find the storage definitions for a cluster,
index, or table.
Anybody out there who can give me a hint or workaround to export my entire
database?
Further explanations:
I think this behavior is not caused by bug 182656. Because of this bug, the
index
for a primary or unique key constraint is created in a schema that is
different from
the table's schema.
Export expects these indexes to be owned by the table owner.
If it cannot find them in the owner's schema, it errors out with EXP-3.
But there is definitely no index created in a schema that is different from
the table's schema.
Therefore the following Workarounds gives no result:
- Run the export as SYS.
- Disable the primary or unique key constraint, do the export, and
then re-enable the constraint.
- Drop the primary or unique key constraint, recreate it in the table
owner's schema, and then run the export. This will actually fix
the problem for the table involved.
Best regards
Henrik Bachmann mailto:[EMAIL PROTECTED]
B.I.M.-Consulting Magdeburg http://www.bim-consulting.de/
D-39108 Magdeburg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bachmann, Henrik
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
