"In Oracle 10g it is possible to track changed blocks using a change tracking file. Enabling ...
To store the change tracking file in the database area, set DB_CREATE_FILE_DEST in the target database. Then issue the following SQL ...
alter database enable block change tracking using file /u01/oracle/product/10.2.0 /db_1/oradata/mydb/blk_track.trc';. If there is already a file named blk_track.trc ...
This section assumes that you intend to create the block change tracking file as an Oracle Managed File in the database area, which is where the database
Enable block change tracking, ALTER DATABASE ENABLE BLOCK CHANGE
TRACKING [USING FILE
But here we need to enable it by specifying using clause. SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/u01/ ...
Enabling can be done by an “alter database” command that will create a block change tracking file. The CTWR process, the change track writer, ...
alter database enable block change tracking using file '/hqlinux01db05/ORACLE/ test/block_change.dbf';. Database altered. select filename ...
Block change tracking file is 1/30,000 the size of the data blocks being
SQL> alter database enable block change tracking using file '+DBDATA/ TESTRAC/bct.dbf' ; Database altered. When data blocks change, ...