[oracle@orcl 2025_05_21]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 24 13:01:35 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
SQL>
SQL> SELECT status, filename FROM v$block_change_tracking;
STATUS FILENAME
---------- ------------------------------
DISABLED
SQL>
SQL>
SQL> select filename form v$datafile;
select filename form v$datafile
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/DB1/system01.dbf
/u01/app/oracle/oradata/DB1/sysaux01.dbf
/u01/app/oracle/oradata/demo1/undotbs01.dbf
14 rows selected.
SQL> alter database enable block change tracking using file '/u01/app/oracle/block_change_tracking.f';
Database altered.
SQL> select * from v$block_change_tracking ;
STATUS FILENAME BYTES CON_ID
---------- ------------------------------ ---------- ----------
ENABLED /u01/app/oracle/block_change_t 11599872 1
racking.f
SQL>
No comments:
Post a Comment