1 Reply Latest reply: Oct 22, 2009 11:05 AM by 543302 RSS

    Error ORA-20067 when simulation partitioning

    user603925
      Tests with based on OBE sample (ilm_data.sql)

      Selected Lifecycle Table : TTL.SALES
      "Preview Simulation" then error: ORA-20067: No valid read-only tablespace found on tier 111

      Any ideas?
        • 1. Re: Error ORA-20067 when simulation partitioning
          543302
          Hi,

          I believe it indicates that you need to define a read-only tablespace for the referenced storage tier. When a lifecycle stage specifies the data to be read-only when it enters, ILMA will lookup the associated storage tier for the stage. Then, it must find a read-only tablespace on that tier. When you attempted to preview your simulation, the rule engine detected the missing tablespace.

          To resolve this, go back to the storage tier setup and choose a tablespace for read-only data. Note, it can be a read-write tablespace as ILMA will pretend to clone the selected tablespace during simulation.

          Greg