Menu de navegação

[souzaParticipante]

EXP-00003: nenhuma definição de armazenamento localizada para o segmento (12, 723)

Acontece esse erro em apenas uma tabela e ela não exportada, alguém já viu isso ?

[DanielBParticipante]

Applies to:
Oracle Server – Enterprise Edition – Version: 10.2.0.2.0
This problem can occur on any platform.

Symptoms
When attempting to perform an export, the following error occurs:

ERROR
EXP-00003: no storage definition found for segment(76, 66347)
Cause
Problem caused by an index on the object being owned by a different user..

When trying to export an object all associated objects are exported as well. If one of the
indexes is owned by a user and the exporting user does not have permissions on that index object
the export fails.
Solution
Redefine the index to be owned by the correct schema owner.
Errors
EXP-3 “no storage definition found for segment(%lu, %lu)”

[DanielBParticipante]

fact: Oracle Server – Enterprise Edition 8.1.6
fact: AIX-Based Systems
fact: EXP
symptom: EXP-00003: no storage definition found for segment(%lu, %lu)
cause: This is Bug 1080833.

Two oracle users A and B exist.
A owns a table T1 and has an index I1.
B creates an index I2 on T1.
When we export T1 as A , this fails with EXP-00003
no storage definition found for segment(%lu, %lu)
The file and the block specified belong to the I2 index created by B.

fix:

Fixed in 8.1.6.2 and 8.1.7
Workaround is to use system/manager for the export

[Autor]

Posts