2 Replies Latest reply: Apr 8, 2008 3:36 AM by Learco Brizzi RSS

    Secure Files vs ILM

    Learco Brizzi
      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
          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
            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