Hello !
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.
The Oracle Database version is 10.2.0.4.0 and the command line we use is :
expdp "'SYSTEM/manager@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip_address>)(PORT=<port>))(CONNECT_DATA=(SID=<oracle_sid>)))'" SCHEMAS=OWNER DIRECTORY=DIR_DP DUMPFILE=dumpfile.dmp FULL=y
What did i miss ?
On a structure-like database on a second test environnement the tables are expdp regularly ...
Thank's for your answers !
Steve.