Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Aug 5th, 2020, 5:16pm
News: Welcome to Pete Finnigan's Oracle security forum
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle Security
   Oracle Security
(Moderator: Pete Finnigan)
   Need to make copy of old data and save for audit
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Need to make copy of old data and save for audit  (Read 1769 times)
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
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.
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Need to make copy of old data and save for aud
« Reply #1 on: May 21st, 2009, 9:52am »
Quote | Modify

Hi,
 
There is really no such thing as read-only in Oracle - there is always ways that you can come up with to read the data. Oracle 10g brought in read-only tablespaces so you could use those. I wrote some blog entries on read-only users and data a long time ago. Have a look at http://www.petefinnigan.com/weblog/archives/00001174.htm and http://www.petefinnigan.com/weblog/archives/00000033.htm. You can also search in google for "read only site:www.petefinnigan.com" - http://www.google.com/search?hl=en&q=read+only+site%3Awww.petefinnig an.com&aq=f&oq=&aqi= as i have written on the subject of read only a few times.
 
hth
 
cheers
 
Pete
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | Next topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board