This discussion is archived
2 Replies Latest reply: Apr 8, 2008 1:36 AM by Learco Brizzi RSS

Secure Files vs ILM

Learco Brizzi Oracle ACE
Currently Being Moderated
I'm working on a document management system and want to use ILM (for archiving and performance). I also want to store the documents with XMLDB or Secure files. Is this possible?

Thanks,
Learco
  • 1. Re: Secure Files vs ILM
    325351 Newbie
    Currently Being Moderated
    le ILM does not offer an archiving capability

    Why do you want to archive?

    If you partition your data correctly, use VPD policies to restrict access to all data. Use cheap storage to store old data and set the old data to read-only so its not included in the backup then you shouldn't need to archive.

    Archiving is very difficult to setup correctly and takes a lot of time. Maintaining all the relationships is quite a challenge

    Personally my first choice would keep all the data in the database. Consider a central archive database and use features like transportable tablespace to move the data quickly. Then you only remove data from the database when you no longer need it.

    Lilian
  • 2. Re: Secure Files vs ILM
    Learco Brizzi Oracle ACE
    Currently Being Moderated
    Thanks for the reply.

    With ILM it should be possible to partition the data of a table over different tablespaces using different media. Problem (or question) that I have is the fact that XML DB isn't a 'simple table' to partition and I wanted to know if it was possible somehow.

    Learco