Steps to Fix Export Issues with expdp full=y Not Exporting All Tables

If a point-in-time recovery is not an option, follow the steps below:

1. Backup the Database as sys user.
2. We will have to patch fed$apps and obj$.
3. startup restrict;
4. Create backup tables:create table backup_fed$apps as select * from fed$apps where APP_NAME = ‘_CURRENT_STATE’;
   create table backup_obj as select * from obj$ where bitand(flags, 134217728)=134217728;
5. Update the necessary records:update fed$apps set APP_STATUS = 0 where APP_NAME = ‘_CURRENT_STATE’;
   commit;

   update obj$ set flags = flags – 134217728 where bitand(flags, 134217728) = 134217728;
   commit;

6. shutdown abort;
7. startup
8. Retry the Export