Source Extractor - SQL PLSQL - Tables not created from the extraction

This page outlines the cases where you find some of the tables are not created even if they are present in the extraction.
You run the oracle database extractor and get no warnings or error in DMT but many important tables are missing from the codebase.

The solution is to

1. Re-run the extraction by selecting all the missing schema.
   For example:
   If you search for one of the missing tables in oracle extraction files you may find the following:
   CAST_ANSISQL_SynonymObjectTarget objectOwner="ADPSEC" objectName="ADP_USER" objectMetatype="CAST_Oracle_RelationalTable"
   in one of the .uax file, but no corresponding table is created.
   These tables or other objects can be found missing since the schema it belongs to is not a part of the extraction. i.e. "ADPSEC".
2. If you have some other objects missing then you can try, grepping on the UAX files folder and find out the missing schema as above.