Differences

This shows you the differences between two versions of the page.

--- flashback_query_with_database_in_noarchivelog_mode [2018/12/06 21:05] – created 91.177.234.129
+++ flashback_query_with_database_in_noarchivelog_mode [2019/01/30 11:32] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Flashback_query_with_database_in_noarchivelog_mode ======
 Typically, development databases are not started in archivelog mode. This causes a problem for hot backups but not necessarily for flashback queries.
 You can still flashback to any time within the online redo logs:
+<code>
  alter session set nls_timestamp_format = 'dd-mon-yyyy hh24:mi:ss.ff3';
  set lines 9999
@@ Line 10: / Line 9: @@
  set headi off
  spool old_version.sql
+</code>
+<code>
  select text
  from   dba_source
  as of  timestamp to_timestamp('22-sep-2011 07:30:00.000')
  where  1=1
@@ Line 19: / Line 20: @@
  order  by type
  ,      line;
+</code>
+<code>
  spool off