Enable/Changing block change tracking file

Moving block change tracking file to different location in oracle:

Check the current file location using below command:

SQL>select status,FILENAME from v$block_change_tracking;

copy the file to new location where you want to relocate. execute the following steps.

SQL> alter database disable block change tracking;

REUSE clause is for using the existing BCT file without creating new file.

SQL> alter database enable block change tracking using file '<file_location>' reuse;

If you want to create new BCT file you just exclude the REUSE clause as below.

SQL> alter database enable block change tracking using file '<file_location>';

Check the filename whether its reflecting new filename or not.

SQL>select status,FILENAME from v$block_change_tracking;