Pete Finnigan
PeteFinnigan.com Administrator
    

Oracle Security is easier if you design for it
View Profile | WWW | Email
Gender: 
Posts: 309
|
 |
Need to make copy of old data and save for audit
« on: May 13th, 2009, 10:16pm » |
Quote | Modify
|
We have an old oracle 8.1.7 DB. The application was home grown but the data needs to be kept from a certian group of tables. It has been suggested that I copy the information from the old database into a new tablespace in the new db and make it read only another suggestion was to pull out the data and put it into Access. The trick is it has to be kept in a readonly format and it's only a chunk of the data in each of the requested tables. I've never done either and am not sure what the best route is. Any suggestions or ideas about how to achieve this would be greatly appreciated. I need to get it completed ASAP, thanks in advance.
|