Re: export/import question

I would use a modified version of the ASCII export technique using a report writer like Crystal or others that can export in delimited ascii. These should retain accessablity regardless of access method needed in the future - With lots of data it will be a large solution ( but the files could be compressed after export for storage ).

Hope it helps,
John Greco
Reply to: john.greco_at_dot.state.mn.us

"Matthew Reagan" <mreagan_at_fast.net> wrote:

>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