This content has been marked as final. Show 4 replies
I guess since there has been no response, the answer is this cannot be set or maintained during the upgrade.
I guess the workaround is to add to checklist before to verify and after to change back.
This should be included in some best practice information somewhere (if not already).
Thanks for confirming/re-inforcing this!
Are you stating that the upgrade process is changing or resetting data in DBA_DIRECTORIES ? It should not - if you have documented this experience, pl report it to Support - it may be a known bug or a new one.
The increase in size of the database should only be restricted to SYSTEM and SYSAUX tablespaces (and possibly TEMP and UNDO), but user tablespaces should see no increase.
I can confirm that the DATA_PUMP_DIR directory is being reset as part of the 188.8.131.52 upgrade.
We've had to add a step to our upgrade checklist to reset it back to the original parameter.