Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center