Exp 11.2 failing to export all tables
a strange thing happened to me, I made an export with exp11.2 against a server 11.2 and out of 154 tables, only 63 have been exported. I have never seen that over about 20 years of using this utility.
On closer inspection I found that the tables which were not exported are all empty, but some of the empty tables were exported . I tried to use Oracle 10g export, but the result was the same.
The export command was simple: exp user/pwd@alias file=name.dmp log=name.log.
The tables are really missing in the dmp file, actually I found the problem when trying to import the file and creating foreign keys failed.