EXP-00003: no storage definition found for segment

From: Bachmann, Henrik <Henrik.Bachmann_at_bim-consulting.de>
Date: Tue, 17 Apr 2001 00:01:30 -0700
Message-ID: <F001.002EA874.20010416235519@fatcity.com>

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:Henrik.Bachmann_at_bim-consulting.de

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: Henrik.Bachmann_at_bim-consulting.de

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: ListGuru_at_fatcity.com (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).

Received on Tue Apr 17 2001 - 02:01:30 CDT