This content has been marked as final. Show 3 replies
Please list the data for this particular table from DBA/ALL_TABLES and DBA_SEGMENTS.
966918 wrote:which schema owns the "missing" object?
There are missing tables in an expdp dump of a database we use in a test environnement.
I don't know why ...
The datafile seems not to be corrupted. The table is listed in a tool like TOAD, and is listed in the catalog view DBA_TABLES.
But the expdp logs doesn't list this table while listing other tables from the same user.
If i try to expdp only a table of these (a missing table in the dumpfile), i get a 39166 Object not found error.
I see that a similar problem may occur in Oracle 11g due to event 10195 set in the init file ( Zero Row Exported And ORA-39166 During EXPDP [ID 1269422.1] )
It could be worth to check you init parameters and remove that setting if it's there. If the export is successfull then you can change init parameters back to the original state.
Edited by: Max Seleznev on Nov 23, 2012 10:51 AM