RE: oracle total recall
Date: Sat, 28 Apr 2012 06:29:06 -0500
Thank you very much for your attention and involvement.
I took a look at the sample code. It includes two wrapped packages (dbms_fda_mappings and dbms_fda_import), so those components are not usable as 'sample code' (i.e. I can not produce my own solution using these as examples).
So this solution requires that I have these packages. They are not installed with the database (Enterprise Edition 188.8.131.52); they do not appear in the 'PL/SQL Packages and Types Reference'; and searches for these names via MyOracleSupport or Google turn up nothing.
If I can use the packages delivered with this download, then I can
proceed. But the license says things like:
- If you use the application you develop under this license for any
internal data processing or for any commercial or production purposes,
or you want to use the programs for any purpose other than as permitted
under this agreement, you must obtain a production release version of
the program by contacting us or an Oracle reseller to obtain the
- You may not: ... use the application you develop with the programs for any internal data processing or commercial or production purposes without securing an appropriate license from us;
So, it appears that the only place I can get these packages is from this 'sample code' download. But I am not allowed to actually use them to solve a real problem.
Can you suggest how I can proceed?
From: kevin jernigan [mailto:kevin.jernigan_at_oracle.com] Sent: Friday, April 27, 2012 12:49 PM
To: Tefft, Michael J
Cc: Rumpi Gravenstein; jobmiller_at_yahoo.com; remigiusz.sokolowski_at_nordea.com; oracle-l Subject: Re: oracle total recall
There is no OTN article (yet) on the sample code for uploading history - there are some comments in the SQL scripts themselves - but we will add an article soon.
Let me know if you have questions in the meantime...KJ
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/27/2012 5:53 AM, Tefft, Michael J wrote:
> Is there an OTN article? Or just the sample code?
> Mike Tefft
> From: kevin jernigan [mailto:kevin.jernigan_at_oracle.com]
> Sent: Thursday, April 26, 2012 10:05 AM
> To: Rumpi Gravenstein
> Cc: Tefft, Michael J; jobmiller_at_yahoo.com;
> remigiusz.sokolowski_at_nordea.com; 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:
> 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
> then import history following the process described in an OTN
> (and associated scripts). Unfortunately, that OTN listing was
> a little while ago, and they are working on getting it
> Any progress on this? I am still looking for methods by which a
> and its flashback archive, can be safely moved from one database to