SQL> alter pluggable database pdbanbob close; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE pdbanbob TO TIMESTAMP to_timestamp('2017-03-21 16:14:01','yyyy-mm-dd hh24:mi:ss'); FLASHBACK PLUGGABLE DATABASE pdbanbob TO TIMESTAMP to_timestamp('2017-03-21 16:14:01','yy...
The flashback operation is performed by winding back the data using the undo information, like a consistent get. The time it takes to wind back the data depends on the number of changes that have happened, so flashback queries of volatile data that go back a long time can be slow. Flas...
"time":True, "timestamp":True, "bigint":True, "mediumint":True, "smallint":True, "tinyint":True, "int":True, "smallint":True, "decimal":True, "float":True, "double":True, "longtext":True, "tinytext":True, "text":True, "mediumtext":True } ...
SQL> select current_scn from v$database; CURRENT_SCN --- 11054748 SQL> 注意:闪回查询和undo_retention有直接关系; eg: SQL> update t1 set job='ab' where id=1; 3 rows updated. SQL> select versions_starttime,versions_endtime,versions_xid,versions_operation,id,sal from t1 versions between t...
Database opened. SQL> SQL> select * from t1; ID SAL JOB --- --- --- 1 9 z 1 2 a 2 3 b 3 4 c 1 3 b 2 1 a D 7 rows selected. SQL> select xidusn,ubafil,ubablk from v$transaction; no rows selected SQL> delete from...
FLASHBACK PLUGGABLE DATABASE pdbanbob TO TIMESTAMP to_timestamp('2017-03-21 16:13:01','yyyy-mm-dd hh24:mi:ss'); flashback pluggable database pdb01 to scn 1628859; alter pluggable database pdbanbob open resetlogs; 如果使用的shared undo模式下PDB闪回数据库,语法有点不同,就是你需要制定辅助...