Re: export/import question

Amit,

I am grappling with the same problem. We have data that is no longer actively used, but may be accessed up to 15 years from now. Export is not an acceptable archiving tool. We are building a utility that will reverse engineer the create statements for a table, its indexes, constraints, storage, etc. and store them in ASCII. It will also extract the contents of the table, placing it in ASCII with the first record describing the column order. The tool we are building will be in SQR, but, if we need to use another product to reload the data in 15 years, we have it stored in the most elemental fashion. Hell, we could even load the data into Excel (assuming Microsoft is still around and Excel version 29 can read delimited records) if the SQL statements are no longer relevant to the database technology of the day.

This is space intensive, but CDs have a long shelf life, and can hold quite a bit for very little money.

Anyone else got any realistic approaches?

Matt...

Amit Aggarwal <amaggarwal_at_kendle.com> wrote in article <3458F16D.147C_at_kendle.com>...
> Hi:
>
> I have a question about export/import in Oracle.
>
> Currently we have Oracle 7.1.3. database running on Dec. Alpha running
> Digital Unix 3.0. We have many schemas in the database and we keep
> archiving them as those studies/schemas are completed. Normally we do
> not need the schema again but sometimes we may. I am sure an export of
> 7.1.3 could be imported into 7.3, but we would like to archive for more
> than 5 years. Now my quesion is that - If I create an export file of a
> 7.1.3 database/schema, can I use that export file to import it into an
> Oracle 8 database, with no problem. I am visualing that 5 years down the
> road, we would be on Oracle 8 and will have no access to 7.1.3. The data
> is extremely critical and we cannot aford to lose it.
>
> thanks for the replies.
>
> amit
>
Received on Fri Oct 31 1997 - 00:00:00 CST