To move/rename current block change tracking file, one would need to restart the database. # Get current block change tracking file SQL> SELECT filename FROM v$block_change_tracking; FILENAME -------------------------------------------------------------------------------- /tmp/blocktracking.f # Shutdown database and start database in mount state SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP MOUNT; # Rename block tracking file and SQL> ALTER DATABASE RENAME FILE … Continue reading How to rename block change tracking file?
Tag: rename
How to change logical name of SQL Server database?
To change the logical name of the SQL Server databse one can follow the steps below to change the logical name of database data file and log file. You may want to take a backup of the database before applying the change to ensure you have a rollback. Example: Use test select fileid, name, filename … Continue reading How to change logical name of SQL Server database?
alexlima.com 