Is there an OTN article? Or just the sample code? Thanks, Mike Tefft From: kevin jernigan [mailto:kevin.jernigan@xxxxxxxxxx] Sent: Thursday, April 26, 2012 10:05 AM To: Rumpi Gravenstein Cc: Tefft, Michael J; jobmiller@xxxxxxxxx; remigiusz.sokolowski@xxxxxxxxxx; oracle-l Subject: Re: oracle total recall The OTN article has been re-posted. In OTN, go to the Sample Code section, then navigate to "Database EE PL/SQL", and the very first listing should be titled "Flashback Data Archive: History Import Scripts". Or you can log in to OTN and go here: http://www.oracle.com/technetwork/indexes/samplecode/plsql-sample-522110 .html Kevin Jernigan Senior Director Product Management Advanced Compression, Hybrid Columnar Compression (HCC), Database File System (DBFS), SecureFiles, Database Smart Flash Cache, Total Recall, Database Resource Manager (DBRM), Direct NFS Client (dNFS), Continuous Query Notification (CQN), Index Organized Tables (IOT), Information Lifecycle Management (ILM) (650) 607-0392 (o) (415) 710-8828 (m) On 4/26/2012 5:03 AM, Rumpi Gravenstein wrote: According to the Total Recall Product Manager, yes, you can export and then import history following the process described in an OTN article (and associated scripts). Unfortunately, that OTN listing was taken down a little while ago, and they are working on getting it re-posted. Any progress on this? I am still looking for methods by which a table, and its flashback archive, can be safely moved from one database to another. -- Rumpi Gravenstein -- //www.freelists.org/webpage/oracle-l