How can I correct the location of a Tablespace Datafile in the pdb
Oracle Database 21c Standard Edition 2 Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
Hello
I wanted to move the sysaux tablespace as per How to Relocate the SYSAUX Tablespace (Doc ID 301186.1)
I used method 2
METHOD 2 (move the datafiles in mount mode)
====================================
1) SHUTDOWN IMMEDIATE
2) Relocate the SYSAUX datafile(s) to the desired location
3) STARTUP MOUNT
4) ALTER DATABASE RENAME FILE
'/FULL_PATH_OF_OLD_LOCATION/AND_DATAFILE_NAME.DBF'
TO
'/FULL_PATH_OF_NEW_LOCATION/AND_DATAFILE_NAME.DBF';
5) ALTER DATABASE OPEN;
The problem is after doing this the CBD reports the correct location NEW of the SYSAUX datafile however the PDB still reports the OLD location of the SYSAUX datafile.