I'd like to figure out the best way to archive the data that is no needed anymore, in order to improve the application performance and also to save disk space. In your experience what is the best way to implement this, what kind of tools can I use? It is better to develop an specific in house application for that purpose?
A:
I would export the data to a comma-delimited file so it can be exported into almost any database. So if you change versions of Oracle or go to something else years later you can restore it without much concern.
Use the spool file feature of SQL*Plus to do this: http://cisnet.baruch.cuny.edu/holowczak/oracle/sqlplus/#savingoutput
Todd Moses
2009-11-11 21:17:13
This is a legitimate operation that is documented in Oracle SQL. There is proof in the link.
Todd Moses
2009-11-12 13:29:26
For anything other than small amounts of data, this is a poor option. It has difficulty with complex datatypes and even with simple VARCHAR2 columns that might contain the delimiter.
Gary
2009-11-12 22:06:35
A:
I would recommend you look at the tools from Solix Technologies; you can visit at www.solix.com
Sanju
2009-11-12 07:10:11