1 Reply Latest reply on Oct 22, 2009 4:05 PM by 543302

    Error ORA-20067 when simulation partitioning

      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

          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.