Showing posts with label block change tracking. Show all posts
Showing posts with label block change tracking. Show all posts

Wednesday, May 14, 2014

Enable Block Change Tracking


1. Enable block change tracking

SQL> alter database enable block change tracking using file '+DATA';

Database altered.

2. Check the status of block change tracking

SQL> SELECT * FROM V$BLOCK_CHANGE_TRACKING;

STATUS
----------
FILENAME
--------------------------------------------------------------------------------
     BYTES
----------
ENABLED
+DATA/cvrman/changetracking/ctf.279.847591985
  11599872